Macros & Excel VBA

How to Rename Sheet with VBA in Excel (Both Single and Multiple Sheets)

In this article, I’ll show you how you can rename the sheet with VBA in Excel. You’ll learn to rename both a single sheet and a group of sheets with ...

Macro to Delete Row in Excel If Cell is Blank

In this article, I’ll show you how to develop and run a Macro in Excel to delete a row if the cell is blank. You’ll learn all the steps from opening ...

Excel VBA Code to Delete Rows Based on Multiple Cell Value (3 Criteria)

In this article, I’ll show you the VBA code to delete rows in Excel based on multiple cell value. You’ll learn to delete rows when multiple cells ...

How to Create and Use ColorFunction in Excel

In Excel, there is no function to make calculations based on the color of the cells. But by using Microsoft Visual Basic for Applications (VBA) it is ...

VBA to Transpose Array in Excel (3 Methods)

Implementing VBA is the most effective, quickest and safest method to run any operation in Excel. In this article, we will show you how to transpose ...

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

In this article, I’ll show you how you can insert rows in Excel based on cell value with VBA. You’ll learn to insert rows after each row, as well as ...

Delete an Excel Row If a Cell Contains Specific Values (3 Methods)

While working with data in Excel, the deletion of an Excel row is quite a common phenomenon. There are a good number of methods that we can use to ...

Excel Delete Rows in a Range with VBA (3 Easy Ways)

In this article, I’ll show you how you can delete rows in a range with VBA in Excel. You’ll learn to use VBA to delete every nth row, rows with a ...

VBA Macro to Insert Row in Excel Based on Criteria (4 Methods)

Sometimes we need to modify our large dataset in Excel by inserting rows based on certain conditions. Implementing VBA macro is the most effective, ...

VBA to Delete Entire Row based on Cell Value in Excel (3 Methods)

Sometimes we need to remove an entire specific row from a huge dataset of rows in Excel. When the cells in the dataset are carrying values, then we ...

How to Remove Spaces in Excel: With Formula, VBA & Power Query

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Remove the First Character from a String in Excel with VBA

In this article, I will show you how you can remove the first character from a string in Excel with VBA. You’ll learn two easy procedures to remove ...

VBA to Remove Numbers from String in Excel (4 Methods)

While working with a large dataset, sometimes you may need to remove certain numbers from the data. To do this manually is really time consuming and ...

How to Delete Infinite Rows in Excel (5 Easy Ways)

There’s something common and irritating about spreadsheets with unnecessary rows or blank rows. But the good news is there are lots of ways to get ...

How to Add Space between Rows in Excel

To add space between rows, we need to insert blank cells between them. We can do it manually by right-clicking, pressing the keyboard shortcut, or ...

ExcelDemy
Logo