Macros & Excel VBA

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

VBA Read Text File into Array (2 Suitable Methods)

While working in Excel, we often need to read and extract texts from a text file into array using VBA code. For a small text file, we can do this ...

How to Add Sheet After Current One with Excel VBA (3 Variants)

In terms of working with many sheets, we might face the necessity of adding a new sheet after the current one. We can use VBA for this purpose. In ...

How to Find Row Number Using VBA in Excel (4 Macros)

We can find row numbers in Excel using many ways but VBA offers more features and customizations. By which we can find row numbers in smart ways. ...

How to Compare Dates to Today with Excel VBA (3 Easy Ways)

Typical Excel datasets contain hundreds of rows and tens of columns. As a result, users often use Excel VBA compare dates to today to highlight or ...

Excel VBA: Copy Range to Clipboard (7 Suitable Examples)

In Microsoft Excel, you can copy the range to the clipboard using the VBA code. In this article, we will show several examples to copy range to the ...

Excel VBA: Clear Contents If Cell Contains Specific Values

Sometimes you need to clear contents if the cell contains several items in Excel VBA. It can be a numeric value, text, date, specific value, or ...

Excel VBA: Find String in Column and Return Row Number

If you are looking for special tricks to know how to find a string in a column and return the row number using VBA code in Excel, you've come to the ...

ExcelDemy
Logo