Macros & Excel VBA

How to Copy Formula Down Without Incrementing in Excel

While working in Excel, we often have to copy down one formula to another group of cells without incrementing. Today I will be showing three easy ...

How to Convert Number to Words in Excel (4 Suitable Ways)

Spreadsheets are used by many people in their daily jobs, making them an important element of their office. While the majority of people use ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

This article will show you how to insert the square root symbol in Excel. Sometimes you may need to store irrational numbers as data in an Excel ...

How to Auto Populate Date in Excel When Cell Is Updated (2 Methods)

Sometimes, several people work on a worksheet and anyone can update the worksheet anytime. So, the worksheet owner might want to see the last updates ...

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

How to Use For Next Loop in Excel VBA (10 Suitable Examples)

Are you looking for ways to use the VBA For Next loop in Excel? Then this is the right place for you. A loop is used when we need to run an ...

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo