Macros & Excel VBA Archives - Page 40 of 70

Excel VBA: Print Range of Cells – 5 Easy Methods

Aug 4, 2024

This is the sample dataset. Method 1 - Using the Excel VBA PrintOut Method to Print a Range of Cells Steps: Open Visual Basic in the ...

Excel VBA: Print Range of Cells – 5 Easy Methods

How to Use the VBA Code to Create a Custom Print Button in Excel (5 Methods)

Jul 28, 2024

Method 1 - Print Dialog Box Create a button by going to Developer, select Insert and click on the Button Box. Drag the cursor to set ...

How to Use the VBA Code to Create a Custom Print Button in Excel (5 Methods)

Excel VBA: Print UserForm to Fit on a Page (2 Methods)

Nov 11, 2025

In this article, I’ll show you how you can use Excel VBA to print a UserForm to fit on a page. Excel VBA: Print UserForm to Fit on a Page (2 ...

Excel VBA: Print UserForm to Fit on a Page (2 Methods)

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

Jun 5, 2024

Sometimes due to technical issues AutoFilter gets hidden, or even though there is no filter applied, Excel shows that there is. In both cases, it can ...

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

Using a VBA Code to Filter Data in Excel – 8 Examples

Aug 3, 2024

The following dataset contains students’ Gender, Status, and Age. Example 1 - Using a VBA Code to Filter Data Based on Text Criteria in ...

Using a VBA Code to Filter Data in Excel – 8 Examples

How to Filter a Dataset Based on a Cell Value from Another Sheet Using VBA (4 Methods)

Jul 25, 2024

Dataset Overview Let’s introduce our dataset first. We have a list of sale details for 4 different products from 2 categories. We want to filter ...

How to Filter a Dataset Based on a Cell Value from Another Sheet Using VBA (4 Methods)

Filter Different Columns by Multiple Criteria in Excel VBA – 3 Methods

Aug 9, 2024

This is the sample dataset. Method 1 - Filtering Different Columns by Multiple Criteria Using the VBA With Statement To Filter TVs costing ...

Filter Different Columns by Multiple Criteria in Excel VBA – 3 Methods

How to Format Cell and Center Text with Excel VBA (5 Ways)

Jun 21, 2024

Method 1 - Run a VBA Code to Center Text Horizontally and Format Cell with Excel VBA 1.1 Center an Active Cell Horizontally In the image below; ...

How to Format Cell and Center Text with Excel VBA (5 Ways)

Import Data from Excel into Word Automatically Using VBA (2 Ways)

Apr 30, 2024

Once you've read these methods, you will learn how to import data from an Excel file into a Word file automatically after running VBA code and by ...

Import Data from Excel into Word Automatically Using VBA (2 Ways)

Excel VBA to Select Used Range in Column (8 Examples)

Jul 19, 2024

In the following image, we can see the dataset that we will use for all the examples. The dataset contains the names of Salespeople, their Location, ...

Excel VBA to Select Used Range in Column (8 Examples)

Excel VBA: R1C1 Formula with Variable (3 Examples)

Nov 11, 2025

While working in Excel, you might hear the absolute and relative cell references. We can use both types of reference in the R1C1 formula with ...

Excel VBA: R1C1 Formula with Variable (3 Examples)

Excel VBA: How to Set Print Area Dynamically (7 Ways)

Jul 6, 2024

Method 1 - Setting Print Area Using a Dynamic Named Range Step 1: ➤ Go to the Formulas Tab >> Defined Names Group >> Name Manager ...

Excel VBA: How to Set Print Area Dynamically (7 Ways)

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

Nov 11, 2025

In this article, I’ll show you how you can auto-filter values that are not equal to a certain value with VBA in Excel. You’ll learn to auto-filter ...

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

Excel VBA: Format Currency with Two Decimal Places – 3 Methods

Aug 14, 2024

Entering the Code in the Visual Basic Editor Go to the Developer tab. Click Visual Basic. Click Insert and select Module. ...

Excel VBA: Format Currency with Two Decimal Places – 3 Methods

How to Filter Based on Cell Value Using Excel VBA (4 Methods)

Apr 25, 2024

Let’s introduce today’s dataset (B4:E15 cell range) as shown in the following screenshot. Here, the Number of Visits for each website is provided ...