Macros & Excel VBA Archives - Page 29 of 70

How to Hide Rows with Zero Values in Excel Using Macro: 3 Suitable Macros

Jul 5, 2024

Method 1 - Applying Macro InputBox to Hide Rows with Zeros in Excel Steps: Bring up the VBA Module window, where we type our codes. From the ...

How to Hide Rows with Zero Values in Excel Using Macro: 3 Suitable Macros

How to Change the Column Header Name in Excel VBA – 3 Examples

Aug 6, 2024

This is an overview. This is the sample dataset. Example 1 - Change the Column Header Name Based on the Cell Property This ...

How to Change the Column Header Name in Excel VBA – 3 Examples

How to Save Chart as Image Using VBA in Excel (2 Easy Methods)

Jun 13, 2024

In general, you can save a chart as an image from the Context Menu by right-clicking. However this gets tedious when you have many charts in your ...

How to Save Chart as Image Using VBA in Excel (2 Easy Methods)

How to Insert Page Break Based on Cell Value with Excel VBA

Jul 15, 2024

We have a dataset with 3 columns: Product, Brand, and Price. We will slightly edit this data for each method. Make sure that the Developer tab is ...

How to Insert Page Break Based on Cell Value with Excel VBA

Excel VBA to Display Print Preview for Multiple Sheets

Nov 11, 2025

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Sometimes, we need to ...

Excel VBA to Display Print Preview for Multiple Sheets

Excel VBA: Print Preview for Selected Range (5 Examples)

Jul 3, 2024

In this article we will demonstrate some methods for printing previews for a selected range of cells in Excel by using Microsoft Visual Basic for ...

Excel VBA: Print Preview for Selected Range (5 Examples)

Excel VBA to Convert Textbox Value to Number (2 Ideal Examples)

Jul 15, 2024

How to Add a Textbox in Excel STEPS: Go to the Developer tab and select the Insert icon. A drop-down menu will appear. Select the Text Box ...

Excel VBA to Convert Textbox Value to Number (2 Ideal Examples)

VBA Code to Compare Two Excel Sheets and Copy Differences

Jul 6, 2024

The sample dataset below will be used for illustration. It contains the Salesman, Product and Net Sales in Sheet1. The 7th and 8th rows are empty. ...

VBA Code to Compare Two Excel Sheets and Copy Differences

Auto Generate Serial Number in Excel VBA (4 Ways)

May 4, 2024

The sample dataset Customer Credentials, into which serial numbers are to be inserted adjacent to those entries. Method 1 - Using ...

Auto Generate Serial Number in Excel VBA (4 Ways)

Using Excel VBA to Capitalize the First Letter of Each Word – 3 Examples

Aug 3, 2024

The dataset contains employee names and their designation. To capitalize the first letter of each word: Example 1 - Using the VBA ...

Using Excel VBA to Capitalize the First Letter of Each Word – 3 Examples

Excel VBA: Get Source Data Range from a Chart (with Quick Steps)

Nov 11, 2025

In this article, I’ll show you how you can get the source data range from a chart using VBA in Excel. Excel VBA: Get Source Data Range from a ...

Excel VBA: Get Source Data Range from a Chart (with Quick Steps)

Excel VBA: If Statement Based on Cell Value: 2 Practical Methods

Jul 6, 2024

Method 1 - If Statement Based on Cell Value of a Single Cell in Excel VBA We’ll learn to use an If statement based on the value of a single cell. ...

Excel VBA: If Statement Based on Cell Value: 2 Practical Methods

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

Jul 13, 2024

Dataset Overview We have a worksheet called Dataset that contains a table with the Country, Revenue, and Earnings of a company. Our objective ...

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

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

May 21, 2024

We will use the sample dataset below to show how to set variables to cell values using VBA. Example 1 - Set Variable to a Single Cell ...

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

Excel VBA: Open Source QR Code Generator

Sep 13, 2025

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