Macros & Excel VBA

How to Find Blank Cells Using VBA in Excel (6 Methods)

In general, Excel workbooks contain numerous cells. And numerous cells are kept blank for multiple reasons. There are multiple ways to find blank ...

Excel VBA to Convert Number to Text (4 Examples)

We can easily change the format of numbers to text using commands in Excel. But it’s not so feasible in all cases. In some particular cases, VBA can ...

How to Delete a Worksheet with No Prompt Using Excel VBA (5 Methods)

While deleting an Excel worksheet, it shows a prompt warning message. When you have only one worksheet to delete, you can easily manage a single ...

Excel VBA: Insert Formula with Relative Reference (3 Ways)

To insert one or more formulas with relative cell references is one of the most important and widely used features that we encounter every day while ...

Excel VBA Codes to Format Cell as Text (3 Easy Examples)

This article illustrates how to format a cell as text using VBA code in Excel with 3 different methods. With the help of the Text and Format ...

How to Change Font Size of the Whole Sheet with Excel VBA

In this article, I’ll show you how you can change the font size of a whole sheet with VBA in Excel. While working in Excel, we sometimes need to ...

How to Use FormulaR1C1 Absolute Reference in Excel VBA

While working in Excel, you might hear the absolute cell reference. This type of cell reference remains unchanged if you copy, move or even use it in ...

Excel VBA: Find the Next Empty Cell in Range (4 Examples)

This article illustrates how to find the next empty cell in a range using VBA code in Excel with 4 different examples. We’ll use Excel’s built-in ...

Excel VBA: Delete Sheet If It Contains Name (4 Ways)

While working with a large Microsoft Excel, sometimes unnecessary data will appear in front of us, and we need to delete unnecessary data and the ...

How to Create Dynamic Drop Down List Using VBA in Excel

In general, Excel worksheets contain numerous rows and columns. To assign an entry to different column values is quite annoying. However, a dynamic ...

How to Make a Dynamic Data Validation List Using VBA in Excel

In dynamic data validation, when you add a new entry to the source list, the entry is automatically added to the data validation list. It is a very ...

Excel VBA: Delete Row If Cell Is Blank (A Complete Guide)

While working with VBA in Excel, we often need to delete a row if any cell is blank. In this article, I’ll show you how you can delete a row if a ...

VBA to Delete Every Other Row in Excel (6 Criteria)

When we have a large amount of data with lots of unnecessary rows in our Excel worksheet, it is hard to understand sometimes. If we remove the rows ...

Excel VBA: Get Cell Value from Another Workbook without Opening

If you are working with different Excel files that contain the same type of information i.e, information of the employees from different departments ...

Excel VBA Codes to Bold Text in a String (5 Examples)

Changing font styles while working with Microsoft Excel is one of the familiar tasks. We perform this in Excel day-to-day. Changing the font style to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo