Macros & Excel VBA Archives - Page 44 of 50

How to Apply VBA Code to Delete Rows Based on Multiple Cell Value (3 VBA Codes)

Jul 17, 2024

Method 1 - VBA Code to Delete Rows when a Single Cell Depends on a Single Value Delete the rows with the students who got 100 in Physics. Steps: ...

How to Apply VBA Code to Delete Rows Based on Multiple Cell Value (3 VBA Codes)

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

May 7, 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 25, 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

Jul 4, 2024

The following GIF provides an overview. Click on the image for a better view. The VBA command will be used to delete an entire row. ...

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

Jul 5, 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 ...

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 Use VBA to Remove Numbers from a String in Excel – 4 Methods

Jun 21, 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?

Dec 21, 2023

In Excel, removing the last character from a string using VBA is quite a simple task to do if you follow the correct steps. In this article, we will ...

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 Delete Row If Cell Contains Value Using Macro in Excel (2 Examples)

Jul 6, 2024

In this article, we will use a VBA macro to delete cells that contain either a string or numbers, as in the following gif. The VBA syntax ...

How to Delete Row If Cell Contains Value Using Macro in Excel (2 Examples)

How to Count Rows with VBA in Excel (5 Approaches)

Jun 4, 2024

In this article we'll cover how to use VBA to count rows from a specific range, from a selected range, by matching a specific criterion, by matching ...