Macros & Excel VBA

VBA to Copy Data to Another Sheet with Advanced Filter in Excel: 3 Methods

Method 1 - Embed VBA Code to Copy Data to Another Sheet with Advanced Filter in Excel Steps: Press Alt + F11 on your keyboard or go to the tab ...

Excel VBA: Delete Files with Wildcards (4 Methods)

VBA allows us to delete any file on the computer by utilizing VBA programs. Using simple VBA programs, we may delete any individual file, specified ...

How to Find Blank Cells Using VBA in Excel: 6 Methods

Method 1 - Check Whether a Specific Cell Is Blank or Not Step 1: Open Microsoft Visual Basic; insert a Module using the instruction section. Paste ...

How to Use Excel VBA to Convert a Number to Text (4 Examples)

The dataset below represents the published article numbers of some writers on a content publishing site named ExcelDemy. The numbers are in number ...

How to Delete a Worksheet with No Prompt Using Excel VBA (5 Methods)

  What Is a Prompt Warning Message? The following VBA code creates a new Excel worksheet and deletes it when you run the code. Sub ...

Excel VBA: Insert Formula with Relative Reference (3 Ways)

In this article, we'll discuss how to use Excel VBA to insert a formula with relative cell references in a single cell or a range of cells. ...

Excel VBA Codes to Format Cell as Text (3 Easy Examples)

How to Use Code in the Visual Basic Editor Go to the Developer tab from the Excel ribbon. Click on the Visual Basic option. In the ...

How to Change Font Size of the Whole Sheet with Excel VBA

In this article, I’ll show you how you can change the font size of a whole sheet with VBA in Excel. While working in Excel, we sometimes need to ...

How to Use FormulaR1C1 Absolute Reference in Excel VBA

While working in Excel, you might hear the absolute cell reference. This type of cell reference remains unchanged if you copy, move or even use it in ...

Excel VBA: Find the Next Empty Cell in Range: 4 Examples

We’ve used a dataset that contains a sale list of a super shop. The dataset has a bunch of empty cells and we want to find them before performing any ...

Excel VBA: Delete Sheet If It Contains Name (4 Ways)

While working with a large Microsoft Excel, sometimes unnecessary data will appear in front of us, and we need to delete unnecessary data and the ...

How to Create Dynamic Drop Down List Using VBA in Excel

Let’s say we have a dataset where Employee Name, Company Name, and Business Addresses are displayed. We want a dynamic drop-down list where we can ...

How to Make a Dynamic Data Validation List Using VBA in Excel (3 Steps)

Step 1 - Create a Dynamic Name Range Go to the Formulas tab and select Name Manager. As a result, a Name Manager window will appear. ...

Excel VBA: Complete Guide To Delete Row If Cell Is Blank

Method 1 - Run a VBA Macro to Delete a Row If the Cell Is Blank in a Single Column with Excel VBA We'll develop a Macro that’ll delete rows with ...

VBA to Delete Every Other Row in Excel (6 Criteria)

When we have a large amount of data with lots of unnecessary rows in our Excel worksheet, it is hard to understand sometimes. If we remove the rows ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo