Macros & Excel VBA

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

[Fixed!] Run Time Error 32809 in Excel VBA 

The run time error 32809 in Excel VBA is quite complicated. Users often find this error irritating. For the same code, some devices will show the ...

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

[Fixed!] Excel VBA InStrRev Not Working

Looking for a way to get rid of the Excel VBA InStrRev Not Working issue? If you are, you’ve come to the right place. This problem can occur for many ...

[Fixed!] Excel VBA Run Time Error 1004

Excel VBA Run Time Error 1004 is a very common error in Microsoft Excel while working with Visual Basic for Applications (VBA) macros. Although it's ...

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

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

Excel VBA MsgBox -11 Examples

  Introduction to the  MsgBox Function in Excel VBA The MsgBox function is used to display a message box in Excel VBA. It is a dialog box that ...

Reasons And Solutions for Excel Object Required Error in VBA

The object required error in VBA occurs when you attempt to perform an operation on a variable or object that is not set or initialized. This error ...

Excel Assign Macro to Button (3 Suitable Examples)

To demonstrate how to assign a macro to a button, we'll use a simple dataset containing student information. We'll sort this data according to the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo