Macros & Excel VBA Archives - Page 63 of 70

How to Create and Use the Color Function in Excel – Easy Steps

Aug 4, 2024

It is possible to make custom functions for calculation based on the color of the cells using the Microsoft Visual Basic for Applications (VBA). ...

How to Create and Use the Color Function in Excel – Easy Steps

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

May 28, 2024

Cells(2,3).EntireRow.Insert This line inserts a row above cell C2 (Row 2, Column 3). Insert Rows Based on Cell Value with VBA: 2 ...

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

How to Delete Row If Cell Contains Specific Values in Excel?

Jul 29, 2024

We will be using a sample dataset that contains the Name and Age of some people. Method 1 - Using Find and Replace to Delete a Row If a ...

How to Delete Row If Cell Contains Specific Values in Excel?

How to Convert Text to Number in Excel with VBA

Jun 16, 2024

How to Identify Numbers Formatted as Text Take a look at this dataset. We have some numbers in a column. Though we have numbers ...

How to Convert Text to Number in Excel with VBA

How to Delete Rows in a Range with VBA in Excel – 3 Methods

Aug 11, 2024

Observe the GIF: Click on the image for a better view. The VBA command will be used to delete an entire row. Customize the command to ...

How to Delete Rows in a Range with VBA in Excel – 3 Methods

Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

Aug 12, 2024

Method 1 - Using a VBA Macro to Insert Rows Based on the Cell Text Value in Excel To insert a new row based on the specific text value “Insert ...

Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

Jul 5, 2024

Method 1 - Use Excel TRIM Function to Remove All Leading and Trailing Spaces The TRIM function removes all spaces from a text string except for ...

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

How to Remove the First Character from a String in Excel with VBA?

Nov 11, 2025

In this article, I will show you how you can remove the first character from a string in Excel with VBA. You’ll learn two easy procedures to remove ...

How to Remove the First Character from a String in Excel with VBA?

How to Use VBA to Remove Numbers from a String in Excel – 4 Methods

Aug 11, 2024

This is an overview. Below is the sample dataset. Method 1 - Delete Leading Numbers from String with Excel VBA Steps: ...

How to Use VBA to Remove Numbers from a String in Excel – 4 Methods

How to Delete Infinite Rows in Excel: 5 Methods

Jul 4, 2024

Method 1 - Changing Sheet Properties to Delete Infinite Rows Steps: Go to the Developer tab in the Ribbon. Click Properties under the Control ...

How to Delete Infinite Rows in Excel: 5 Methods

How to Add Space between Rows in Excel (2 Ways)

Jun 11, 2024

Method 1 - Using the Excel Sort Tool to Add a Space Between Rows Assuming we have a dataset (B4:D9) of the employee names and their total working ...

How to Add Space between Rows in Excel (2 Ways)

How to Remove Last Character from String Using VBA in Excel?

Aug 2, 2024

The following GIF demonstrates the process of removing the last character from a string using VBA in Excel. How to Remove Last ...

How to Remove Last Character from String Using VBA in Excel?

How to Remove Characters from String Using VBA in Excel?

Jul 6, 2024

The sample dataset is the Premier League Point Table of the 2012/13 Season. In the dataset, we have Manchester United as the Champion Team. But in ...

How to Remove Characters from String Using VBA in Excel?

How to Count If Cell Contains Text in Excel (5 Easy Approaches)

Nov 11, 2025

It is not impossible that we might face the necessity to count how many cells contain text within a specific region. In this article, I will try to ...

How to Count If Cell Contains Text in Excel (5 Easy Approaches)

How to Delete Multiple Rows with VBA in Excel (4 Ways)

Nov 11, 2025

In this article, I’ll show you how you can delete multiple rows in Excel with VBA. The article will combine deleting multiple rows of a selected ...