Macros & Excel VBA

Excel VBA to Count Files in Folder and Subfolders (4 Examples)

Counting the number of files in a folder and its subfolders can be a tedious and time-consuming task, especially if there are a large number of files ...

VBA Object Variable or with Block Variable Not Set in Excel

VBA Object variable or With block variable not set is a common error message encountered in VBA programming language. This error often occurs ...

Excel VBA to List Files in Folder and Subfolders 

Managing large amounts of data in Excel can be very challenging, especially when it comes to locating and organizing files scattered across multiple ...

Excel VBA to List Files in Folder with Specific Extension 

Sometimes we need to list files with specific extensions in the Excel worksheets. Obviously, we can do it manually, but it’s quite laborious and ...

How to Solve Overflow Error in VBA (4 Easy Methods)

Have you ever been stuck in the middle of your code where you are continuously trying to make your algorithm better but do not run eventually due ...

Excel VBA Open Workbook Event (All in One)

Are you tired of performing repetitive tasks every time you open an Excel workbook? Do you want to automate your workflow and save time? If your ...

Excel VBA Target Cell: 9 Practical Examples

Looking for ways to interact with a target cell using VBA in Excel? Then, this is the right place for you. If you want to interact with a cell in ...

How to Use Excel VBA Target Range (4 Suitable Examples)

When we work in Excel, sometimes we need to run events when selecting a cell from a specific range that is known as the target address. It’s quite ...

How to Use Excel VBA ComboBox with Control Source Property 

When you use Microsoft Excel, I am pretty sure you often use ComboBoxes in UserForm. Excel provides some unique VBA tools for developing combo boxes. ...

Excel VBA to Sort by Column Header Name (5 Easy Ways)

It's a common practice to sort data in Excel by a particular column header name, especially when working with large datasets. Excel has a built-in ...

Excel VBA to Activate Workbook with Partial Name

Remembering long Workbook names takes extra time and effort. Using VBA, you can activate a Workbook without remembering its full name. Isn’t it ...

Excel VBA to Sort a ComboBox List Alphabetically

The ComboBox is a special feature of Excel. If we ever need to choose from multiple options, VBA ComboBox is there for the job. Not only that, but we ...

Excel VBA to Open Workbook from Path in Cell

We can access a workbook in Excel from a path specified in a cell. This is useful when we want to dynamically refer to a file path that may change ...

Excel VBA to Sort Alphabetically

Data sorting is a common activity when working with Microsoft Excel. I am pretty sure that in some cases, you'll have to sort your cell data ...

Excel VBA to Sort Column Ascending (9 Examples)

Sorting is frequently used by Excel users. The user, therefore, needs a handy and easy procedure to sort columns. For this purpose, VBA code can be ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo