Macros & Excel VBA Archives

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

Dec 2, 2021 Macros & Excel VBA

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

Dec 1, 2021 Macros & Excel VBA

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)

Nov 30, 2021 Macros & Excel VBA

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

Nov 30, 2021 Excel Formulas

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)

Nov 30, 2021 Macros & Excel VBA

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)

Nov 29, 2021 Macros & Excel VBA

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)

Nov 29, 2021 Advanced Excel

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)

Nov 28, 2021 Macros & Excel VBA

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)

Nov 28, 2021 Macros & Excel VBA

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)

Nov 28, 2021 Macros & Excel VBA

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

Nov 30, 2021 Excel Formulas

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

Nov 30, 2021 Macros & Excel 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)

Nov 25, 2021 Macros & Excel VBA

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)

Nov 30, 2021 Macros & Excel VBA

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

Nov 25, 2021 Macros & Excel VBA

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 ...