Latest Blog Posts

[Fixed!] Invalid Forward Reference in VBA

There are several possible causes of an Invalid forward reference error in VBA in Excel, so it can often be tricky to identify the appropriate method ...

Advanced VLOOKUP in Excel

Advanced VLOOKUP in Excel: Knowledge Hub Use VLOOKUP for Multiple Columns VLOOKUP from Multiple Columns with Only One Return Use VLOOKUP ...

Excel VBA to Set Column Width Based on Cell Value (3 Examples)

One of the most frequent actions you complete each day while developing your reports, summary tables, dashboards, or even when using spreadsheets ...

Excel VBA Error Handling in Loop (5 Best Practices)

Here's an overview of how VBA handles errors while performing loops. How to Launch the VBA Editor in Excel Click on the Developer tab ...

How to Use VBA in Excel to Capitalize All Letters (4 Examples)

How to Open the VBA Macro Editor in Excel You will need the Developer tab at the top of the worksheet. Click on the Developer tab and select ...

How to Adjust Column Width Using Excel VBA (6 Methods)

Launching the VBA Macro Editor in Excel Before running any VBA code, you’ll need to access the VBA Macro Editor. Follow these steps: Enable the ...

[Fixed!] Runtime Error 438 in Excel VBA (5 Solutions)

Reason 1 - Incorrect Workbook Reference The following code has an incorrect workbook reference. Running this code will give runtime error 438. To ...

How to Use Excel VBA Like Operator (7 Suitable Examples)

Excel VBA Like operator is a very useful feature that allows you to match one or more specific letters or numbers within a string. In this article, ...

Excel VBA to Find Multiple Values in Range (4 Examples)

Method 1 - Finding Multiple Values from User Input The following code will prompt users to insert a value that they want to find and highlight ...

How to Use a Target Row in Excel VBA (4 Ways)

The video below illustrates how to use Target Row to delete an entire row. By selecting Target Row, we have deleted all rows with marks less than 70 ...

How to Use Excel VBA to Move Files

A File System Object (FSO) is an object in VBA that provides a way to work with files and folders on a computer’s file system. It allows VBA code to ...

Excel VBA Like Operator with Variable (4 Examples)

In this article, we will explore some ways of using Excel VBA Like operator with variable. The Like operator compares a string against a pattern. ...

How to Use Macro to Create Folders from Excel List (3 Methods)

In this article, we will use a VBA Macro to create folders from an Excel list. Multiple folders and subfolders with various names may occasionally be ...

Using Excel VBA to Loop Through Files in a Folder and Copy Data – 4 Examples

This is the sample dataset. How to Launch the VBA Editor in Excel Go to the Developer tab and select Visual Basic. Click ...

How to Use Excel UserForm as Date Picker (with Easy Steps)

Here's a dataset of sales data for a grocery shop. In the Date & Time of Sale column, users have to enter the date and time manually. This is not ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo