Macros & Excel VBA

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

How to Use For Each Loop in Excel VBA (3 Suitable Examples)

A For Each Loop is a piece of code that handles repetitive tasks efficiently without using any repetitive coding blocks. In this article, we ...

How to Use Do While Loop in Excel VBA (3 Examples)

When you would like to repeat a statement as long as the condition meets, you can use the do while loop in Excel VBA. Using the do while loop, you ...

How to Use Do Until Loop in Excel VBA (with 2 Examples)

People like to be adventurous. They do not like to do the same thing again, again and again. In terms of working with VBA, we can skip the same code ...

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function, and the Proper Function, which can change the case of a ...

How to Use For Next Loop in Excel VBA (with 5 Examples)

Loop is used when we need to run an operation operate repeatedly. Without performing the same operation manually every time in Excel, we can apply ...

IF & AND Functions in Excel VBA to Test Multiple Conditions

We have already seen how to use the IF & AND worksheet Functions to test multiple conditions, in a previous tutorial. We are now going to see how ...

How to Use Select Case Statement in Excel VBA (2 Examples)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article ...

How to Use Table Reference with Excel VBA (20 Examples)

In Excel workbooks with large datasets, it can be convenient to refer to a table by its name instead of its whole range. Using VBA in Excel is the ...

Count Frequency of Text in Excel (4 Effective Ways)

Have you ever wondered how to count the frequency of text in Excel, i.e. the number of times a specific text appears in a range? In this article, we ...

How to Use INDEX MATCH with Excel VBA

You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and ...

How to Use Form Controls in Excel (Detailed Analysis)

This article will focus on different types of form controls and how to use them in Excel. You can give your worksheets form-like functionality ...

Best 7 Books on Financial Modelling Using Excel

Where do financial modelers work? The world of finance can be a very complex place that at times is quite tricky to navigate. One has, for example, ...

6 Best Excel VBA Programming Books (For Beginners & Advanced Users)

Do you often find yourself, doing repetitive tasks over and over again in Excel and wishing that somehow, someway these tasks could be automated? ...

How to Create a Body Mass Index Calculator in Excel Using VBA

This tutorial will demonstrate how to create a body mass index calculator in excel using VBA. The Body Mass Index (BMI) is used by nutritionists and ...

ExcelDemy
Logo