Macros & Excel VBA

How to Create a New Sheet from a Template Using a Macro in Excel – 3 Methods

Method 1 - Using a Button in a Template to Create a New Sheet There is only one worksheet Sheet1 in the workbook.   Step 1: Inserting ...

How to Add Sheet with Name from Cell Using Excel VBA

In this article, we will use the following dataset to demonstrate four methods to add a sheet with a name derived from a cell using Excel VBA. In the ...

How to Make Table of Contents Using VBA in Excel (2 Examples)

If you are looking for ways to make a table of contents in Excel VBA quickly, then this article is for you. So, let’s dive into the main article to ...

[Fixed!] Sub or Function Not Defined in Excel VBA

‘Sub or Function not defined’ is a compilation error in Excel VBA, that is displayed whenever anything specified by name cannot be found. Before ...

How to Generate XML File from Excel Using Macro (3 Methods)

The first dataset lists the names that will be applied to the new XML files. This sample dataset will be converted to an XML file. ...

Automation of Bank Reconciliation with Excel Macros: 3 Quick Steps

Method  1 - Create Dataset with Proper Parameters Our dataset contains information about several Transactions, including the Cheque Book Number, ...

How to Unhide All Columns with Excel VBA (8 Examples)

For various reasons, we hide columns and rows in Excel. At the same time, we may need to unhide them for our needs. Unhiding them may involve various ...

How to Insert Page Number Using VBA in Excel: 3 Macros

Method 1 - Insert a Page Number in a Footer Using Excel VBA Steps: Go to Insert, choose Text, and select Header & Footer. Scroll ...

[Solved!] Excel VBA: Status Bar Not Updating [4 Easy Solutions]

Status Bar in Excel can be useful for seeing the progress of certain actions, like page layout changes or printing. However, there are times when the ...

How to Use Excel VBA to Hide Columns Based on Cell Value (15 Examples)

To demonstrate, we have a dataset of 5 students. Their name, department, examination marks, grades, DOB, and retake examination marks are in the ...

How to Remove Gridlines in Excel Using VBA

In this article, we will demonstrate 3 quick ways to remove Gridlines in Excel using VBA. To demonstrate our methods, we will use the following ...

Using Excel VBA to Hide Columns Based on Criteria – 6 Examples

The sample dataset showcases: Salesman, Product, and Net Sales. Example 1 - Apply Excel VBA to Hide Columns Based on the Cell Value X is ...

Excel VBA to Hide Columns Using Column Number (6 Examples)

This article will teach us to hide columns using the column number with VBA in Excel. Usually, excel expresses columns with alphabets. But we can ...

Using Excel VBA to Open a Workbook in the Background – 2 Examples

This is File1. This is File2. Example 1 - Open a Secondary Workbook in the Background with Excel VBA STEPS: Go to the ...

How to Find Special Characters Using VBA in Excel: 3 Quick Methods

Method 1 - Using a Simple User Defined Function to Find Special Characters Steps: Go to the Developer Tab and select Visual Basic. The ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo