Latest Blog Posts

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

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

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

How to Use Excel VBA to Loop Through Files in a Folder and Rename (6 Ways)

How to Launch VBA Editor in Excel You can use the keyboard shortcut to open the VBA code editor in Excel. Let’s see how. Press Alt + F11 to ...

[Fixed!] Excel Application-Defined or Object-Defined Error in VBA

Reason 1 - Incorrect Worksheet Name Causes Application-Defined or Object-Defined Error in Excel VBA This happens when the name of the worksheet is ...

Excel VBA to Pause and Resume Macro: 5 Examples

Method 1 - Use of Ctrl + Pause Break Command to Pause and Resume Macro in Excel VBA We created this data table that will include the Sl. No. from B5 ...

How to Use Excel VBA to List Files in a Folder – 4 Methods

This is an overview. How to Launch VBA Editor in Excel Go to the Developer tab on the ribbon or  enable the Developer tab on your ...

How to Make a Schedule for Employees in Excel (3 Types)

Watch Video – Make a Schedule for Employees in Excel The Advantages of Making Schedules for Employees Time-saving: Excel allows ...

How to Create Shift Roster 24×7 with Excel Automation

  Step 1 - Define Names for the Dropdown List Create dropdown boxes for 3 different items: Month, Year, and Shift. Let's say we have ...

Using Excel VBA to Hide Multiple Sheets – 9 Methods

The Worksheet.Visible Property in Excel VBA The Worksheet.Visible property hides multiple sheets in an Excel file. The Visible property can have one ...

How to Hide and Unhide Sheets in Excel with VBA (6 Examples)

Example 1 - Hide and Unhide a Single Sheet We have a workbook that has five sheets, each containing an imaginary data table of “Records of ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo