Macros & Excel VBA Archives - Page 42 of 70

VBA to Loop through Rows of Table in Excel (11 Methods)

Apr 27, 2024

Consider the following dataset, which we'll use to showcase looping through rows in a table. Method 1 - Embed VBA to Loop ...

VBA to Loop through Rows of Table in Excel (11 Methods)

How to Use VBA for Each Row in a Range in Excel

Jul 24, 2024

In this article, we will demonstrate how to use Excel VBA to iterate through each row in a range effectively, where the rows contain either single or ...

How to Use VBA for Each Row in a Range in Excel

Extract Data from One Sheet to Another Using VBA in Excel (3 Methods)

May 23, 2024

Watch Video – Extract Data from One Sheet to Another Using VBA in Excel Here’s an overview of the sample dataset we will be ...

Extract Data from One Sheet to Another Using VBA in Excel (3 Methods)

Excel VBA: Copy Dynamic Range to Another Workbook

Nov 11, 2025

Different scenarios may arise while using Excel. You may need to copy a range from one workbook to another. We hope, after finishing the article you ...

Excel VBA: Copy Dynamic Range to Another Workbook

How to Select Range from Active Cell Using VBA in Excel: 3 Effective Methods

May 29, 2024

Method 1 - Employing VBA to Select Range from Active Cell to the Last Non-Blank Cell Steps: From the Developer tab >>> select Visual ...

How to Select Range from Active Cell Using VBA in Excel: 3 Effective Methods

Excel VBA: Change Font Color for Part of Text: 3 Methods

May 29, 2024

Method 1 - Change the Font Color for a Specific Part of Text Using VBA in Excel 1.1 Use of the Font.Color Property Along with the above property, ...

Excel VBA: Change Font Color for Part of Text: 3 Methods

How to Copy a Row Using Excel VBA If the Cell Value Matches (2 Methods)

Jul 24, 2024

Dataset Overview We’ll use the sample dataset below to demonstrate two methods. Method 1 - Copy Row to Another Sheet If One Cell Value ...

How to Copy a Row Using Excel VBA If the Cell Value Matches (2 Methods)

Excel VBA to Rotate Text to 90 Degrees (4 Easy Examples)

Jul 26, 2024

We will show 4 VBA code examples to rotate text to 90 degrees. We will use the following dataset for the examples. Example 1 - Excel VBA ...

Excel VBA to Rotate Text to 90 Degrees (4 Easy Examples)

Excel Macro: Sort Multiple Columns with Dynamic Range (4 Methods)

Nov 11, 2025

While working with large Microsoft Excel, sometimes we need to sort multiple columns with a dynamic range. We can easily do that by using the VBA ...

Excel Macro: Sort Multiple Columns with Dynamic Range (4 Methods)

VBA to Loop through Rows and Columns in a Range in Excel (5 Examples)

Jul 16, 2024

We will use a dataset that contains information about the Sales Amount of the first two months of some sellers. Example 1 - Apply VBA ...

VBA to Loop through Rows and Columns in a Range in Excel (5 Examples)

How to Compare Two Tables for Differences with Excel VBA (3 Methods)

Nov 11, 2025

In this article, I’ll show you how you can compare two tables for differences using VBA in Excel. You’ll learn to compare two tables by finding out ...

How to Compare Two Tables for Differences with Excel VBA (3 Methods)

Excel VBA to Loop through Range until Empty Cell (4 Examples)

May 14, 2024

In our sample dataset, some cells in the Salesman column are empty. We'll use VBA loops to locate these empty cells. Example 1 - Excel VBA ...

Excel VBA to Loop through Range until Empty Cell (4 Examples)

How to Autofit Row Height with Wrap Text Using Excel VBA (5 Methods)

Jul 25, 2024

Scenario In this tutorial, we’ll address the issue of the names of the salesperson not fitting in cells in an Excel dataset. By using VBA (Visual ...

How to Autofit Row Height with Wrap Text Using Excel VBA (5 Methods)

Using a Macro to Split a Cell into Multiple Rows in Excel – 8 Steps

Aug 11, 2024

This is an overview: Step 1 - Open the VBA Editor in Excel Select the cell containing the data you want to split, here B2 . Press ...

Using a Macro to Split a Cell into Multiple Rows in Excel – 8 Steps

Excel VBA: Insert Data into Table: 4 Examples

Jun 16, 2024

The sample sale list of a shop contains details like the order date, product name, quantity, unit price, and total price. How to Create a Table ...