Macros & Excel VBA Archives

How to Use Macro to Save Excel File with New Name (5 Ways)

Aug 14, 2022 Macros & Excel VBA

This tutorial will demonstrate how to use a macro to save an excel file with a new name. If you have a particular excel file that you need to use ...

How to ReDim Preserve 2D Array in Excel VBA (2 Easy Ways)

Aug 14, 2022 Macros & Excel VBA

An array is a variable that keeps the same kinds of data. If there is only one row or one column of data, then it is known as a one-dimensional ...

How to Add Sheet with Name in Excel VBA (6 Easy Ways)

Aug 14, 2022 Macros & Excel VBA

This article provides the answers to your questions on how to add a sheet with name in Excel VBA. If you are looking for such unique kinds of tricks, ...

Create New Workbook and Save Using VBA in Excel

Aug 11, 2022 Macros & Excel VBA

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Visual Basic ...

[Fixed!] Unable to Set the Visible Property of the Worksheet Class

Aug 11, 2022 Macros & Excel VBA

If you are looking for some special tricks to solve the problem of “unable to set the visible property of the worksheet class”, you've come to the ...

Excel VBA: Create a New Workbook and Name It (6 Examples)

Aug 10, 2022 Macros & Excel VBA

Looking for ways to know how to create a new workbook and name it using VBA in Excel? Sometimes, we want to create a new workbook with a name in ...

How to Unhide All Sheets in Excel Using VBA (4 Examples)

Aug 11, 2022 Macros & Excel VBA

Sometimes, we have to show all of our hidden sheets in the Sheet Name Bar. Using Excel VBA code, we can do such a task within the blink of an eye. In ...

Excel VBA: Zoom to Fit Screen (4 Suitable Examples)

Aug 10, 2022 Macros & Excel VBA

If you are looking for ways to zoom in to fit a screen using VBA in Excel, then you will find this article helpful. By using the VBA codes of this ...

Excel VBA: Add Sheet After Last (3 Ideal Examples)

Aug 10, 2022 Macros & Excel VBA

Sometimes, you might add an Excel sheet after the last for the convenience of your work. Adding an Excel sheet after the last is an easy task. This ...

Excel VBA to Add Sheet If It Does Not Exist (with Quick Steps)

Aug 10, 2022 Macros & Excel VBA

Excel VBA is a powerful and handy tool to perform tasks pretty quickly in a bulk amount. You can apply several conditions and derive different ...

How to Create New Sheet from Template Using Macro in Excel

Aug 10, 2022 Macros & Excel VBA

If you want to create a new sheet from a template using macro in Excel, you have come to the right place. Here, we will walk you through 3 easy ...

How to Add Sheet with Name from Cell Using Excel VBA

Aug 8, 2022 Macros & Excel VBA

We can save valuable time by using the Excel VBA Macro. Often, we need to add new sheets and name them from a cell manually, but we can do it ...

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

Aug 3, 2022 Macros & Excel VBA

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

Aug 4, 2022 Macros & Excel VBA

‘Sub or Function not defined’ is a compilation mistake in Excel VBA. When anything specified by name cannot be found, VBA shows this warning. Before ...

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

Aug 2, 2022 Macros & Excel VBA

The article will show you how to generate XML files from excel using Macro. Basically, we are going to apply Microsoft Visual Basic for Applications ...