Macros & Excel VBA

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

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

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)

  Method 1 - Using the ThisWorkbook Method in VBA to Refresh an Excel Sheet Automatically Step 1 - Creating the Dataset We will create a ...

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 to 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 of copying range to ...

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

How to Get Row Number from Range with Excel VBA (9 Examples)

If you are looking for special tricks to know "Excel VBA: get row number from range", you've come to the right place. There are numerous ways to get ...

Excel VBA Copy Cell Value to Clipboard (4 Methods)

Most of the time, Excel users manually copy (CTRL+C) cell values and then paste (CTRL+V) them into other cells. Excel VBA copy cell value to the ...

How to Open Workbook with Variable Name with Excel VBA

Naturally, we may need to open the file from a parent Excel file using VBA in a different directory. But at the same time, we have various types of ...

How to Clear Cells in Excel VBA (9 Easy Methods)

If you want to clear cells in Excel VBA, you have come to the right place. Here, we will walk you through 9 easy methods to do the task smoothly. ...

How to Create a Table with Headers Using Excel VBA (2 Methods)

The article will show you how to create a table with headers using Excel VBA. Sometimes, it’s easier to use a VBA command to create tables with ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo