Macros & Excel VBA

[Solved] Spell Number Not Working in Excel

The article will show you how to solve the spell number not working problem in Excel. Basically, Excel doesn’t have any built-in function to spell a ...

How to Highlight Active Row in Excel VBA (2 Suitable Examples)

This article illustrates how to highlight the active row using Excel VBA. Assume you have a large dataset with many columns. Then you may lose track ...

How to Open Workbook as Read-Only with Excel VBA

Naturally, we may need to open the file from a parent Excel file using VBA as a read-only form. For the reason of keeping the original file intact. ...

How to Apply Formula to Entire Column Using Excel VBA

In this tutorial, I am going to show you 3 simple methods on how to apply a formula to an entire column using excel VBA. These methods will save a ...

How to Find Lookup Value in Array in Excel VBA (2 Easy Ways)

Most likely, you’re familiar with lookup value in an array in Excel. What if you need to do the same task using Excel VBA? Sounds interesting. ...

Excel VBA to Clear Contents of Named Range (3 Macro Variants)

The article will show you how to clear the contents of a Named Range in Excel VBA. If your dataset contains Named Ranges and you need to change the ...

How to Declare Array in Excel VBA (3 Easy Ways)

If you want to run a VBA code in Excel, then you first have to declare array. However, if you want to declare arrow in VBA, then you have landed in ...

How to Highlight Blank Cells in Excel VBA (6 Suitable Examples)

Looking for ways to know how to highlight blank cells in Excel VBA? Sometimes, we want to highlight the cells which contain no data or empty strings. ...

How to Check If Array Is Empty with VBA in Excel (3 Variants)

An array is essentially a group of things. The elements may take the form of text or numbers and may be placed in a single row, a single column, or ...

How to Select Visible Cells in Excel with VBA (5 Easy Methods)

If you are looking for special tricks to select visible cells using VBA in Excel, you've come to the right place. There are numerous ways to select ...

How to Find Square Root in Excel VBA (3 Suitable Methods)

It is quite fascinating how easily we can find square root in Excel using VBA codes. Simply by running an Excel VBA code, we can find square roots of ...

Excel VBA: Select Visible Cells After Autofilter (4 Examples)

You can easily apply the auto filter in Excel except using a VBA code. You can also select them too manually which you can also use to perform ...

Excel VBA to Select First Visible Cell in Filtered Range

In this article, we will learn to select the first visible cell in a filtered range with Excel VBA. We can select the first visible cell in a ...

Create a Search Box in Excel with VBA (5 Suitable Examples)

If you are looking for a way to create a search box in Excel with VBA, then this article will be beneficial to you. The focus of this article is to ...

How to Refresh Excel Sheet Automatically Using VBA (4 Methods)

If you want to refresh Excel sheet automatically VBA, you have come to the right place. Here, we will walk you through 4 easy methods to do the task ...

ExcelDemy
Logo