Macros & Excel VBA

How to Create a Dynamic Chart in Excel Using VBA (with Easy Steps)

In this article, I’ll show you how you can create a dynamic chart in Excel using VBA. Watch Video – Create a Dynamic Chart in Excel Using ...

Excel VBA: Set Variable to a Cell Value (3 Practical Examples)

In this article, I’ll show you how you can set a variable to a cell value using VBA in Excel. You’ll learn to set a variable to the value of a single ...

Excel VBA: Open Source QR Code Generator

Here's a quick preview of an open-source QR code generator. Excel VBA: Open Source QR Code Generator (Quick View) Function ...

Excel VBA: Create a Progress Bar While Macro Is Running

Step 1 - Open the Visual Basic Window Press Alt + F11 to open the Visual Basic window. Step 2 - Insert a New UserForm Go to the ...

[Solved]: User Defined Type Not Defined in Excel VBA (2 Quick Solutions)

One of the most common errors that we face while working with VBA in Excel is that the user-defined type is not defined. In this article, I’ll show ...

How to Use Macro to Clean Up Data in Excel (4 Easy Methods)

In this article, I’ll show you how can develop a Macro to clean data from a data set using VBA in Excel. 4 Simple Methods to Develop a Macro ...

Excel VBA: Copy Cell Value and Paste to Another Cell

In this article, I’ll show you how you can copy the value of a cell and paste it to another cell using VBA in Excel. You’ll learn to copy the value ...

Excel VBA: Copy Range to Another Workbook

One of the most widely used tasks that we encounter while working in Excel VBA is to copy a data range from one workbook to another. In this article, ...

Excel VBA: Calculate Distance Between Two Addresses or Coordinates

While working with Microsoft Excel, sometimes we need to calculate the distance between two addresses or coordinates for the convenience of our work. ...

Excel VBA: Close Workbook Without Saving

In this article, I’ll show you how you can use Excel VBA to close a workbook without saving. Excel VBA: Close Workbook Without Saving (Quick ...

How to Filter a Date Range Based on a Cell Value Using VBA (2 Methods)

An Overview of the VBA Code to Filter Date Range Based on Cell Value in Excel We have a dataset in the range B3:D12 containing Delivery Dates, ...

Excel Macro to Save as PDF (5 Suitable Examples)

PDF is a very common file format for documents. In Excel 2010 and later, you can export a workbook, a sheet or group of selected worksheets, or a ...

Excel VBA: Insert Timestamp When a Macro Is Run

In this article, I’ll show you how you can keep a timestamp in Excel VBA every time a Macro is run. Excel VBA: Insert Timestamp When a Macro ...

Excel VBA to Save a File with Variable Names – 5 Examples

Example 1 - Using a VBA Code to Save a File in the Current Location with a New File name Steps: Go to Sheet Name and right-click. Choose ...

Excel VBA: Convert Formula to Value Automatically (2 Easy Methods)

In this article, I’ll show you how you can convert a formula of a worksheet to its value automatically using Excel VBA. Excel VBA: Convert ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo