Macros & Excel VBA Archives - Page 59 of 70

VBA to Check If Font Color is Red Then Return Results in Excel

Nov 11, 2025

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you if the ...

VBA to Check If Font Color is Red Then Return Results in Excel

Change Font Color Based on Value of Another Cell in Excel

Jul 9, 2024

In this tutorial, we will demonstrate how to change font color based on the value of another cell. Here is an overview of the process. To ...

Change Font Color Based on Value of Another Cell in Excel

Excel Align Matching Values in Two Columns

Nov 11, 2025

This article will guide you to understand how to align matching values in two columns in Excel based on the first column in the worksheet. Finding ...

Excel Align Matching Values in Two Columns

How to Concatenate Range with Separator Using VBA in Excel

Nov 11, 2025

In this article, we’ll show you how you can concatenate a range of cells with a given separator using VBA in Excel. You’ll learn to concatenate the ...

How to Concatenate Range with Separator Using VBA in Excel

How to Change Text Color with Formula in Excel (2 Methods)

Jun 14, 2024

We have some book names and their online prices for two consecutive years. We’ll change the color of the prices with the formula. Method 1 ...

How to Change Text Color with Formula in Excel (2 Methods)

How to Delete Row Using VBA?

Nov 11, 2025

Deleting rows in Excel can be done easily using Excel's default functionalities. But sometimes, you might need to use Excel VBA to do so. Or if ...

Excel VBA: Select Multiple Columns (3 Methods)

May 17, 2024

It's simple enough to select multiple columns manually in Excel. But it's also a simple task using VBA codes. Select Single Column Using ...

Excel VBA: Select Multiple Columns (3 Methods)

How to Use VBA Range Based on Column Number in Excel

Nov 11, 2025

Using VBA code is an effective and intelligent way to deal with various tasks in Excel. In this article, you will learn how to use VBA Range based on ...

How to Use VBA Range Based on Column Number in Excel

How to Add a Row to the Bottom of a Table Using an Excel Macro (2 Methods)

Jul 16, 2024

Dataset Overview In this article, we’ve got a table named Table1 in an Excel worksheet that contains the names, starting salaries, and present ...

How to Add a Row to the Bottom of a Table Using an Excel Macro (2 Methods)

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

Jun 14, 2024

Method 1 - Using Find and Replace Step 1: Go to Home Tab > Select Find & Select (in Editing section) > Click on Replace (from the ...

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

VBA to Remove Formulas in Excel Keeping Values and Formatting

Nov 11, 2025

In this article, I’ll show you how you can remove formulas from a worksheet in Excel keeping the values and formatting with VBA. First, you’ll learn ...

VBA to Remove Formulas in Excel Keeping Values and Formatting

How to Remove Non-Alphanumeric Characters in Excel?

Nov 11, 2025

Today, in this article, we will demonstrate how to remove non-alphanumeric characters from cells in Excel. It is a very common problem, especially ...

How to Remove Non-Alphanumeric Characters in Excel?

VBA Range with Variable Row Number in Excel – 4 Examples

Aug 2, 2024

This is an overview: Sub Range_with_Variable_Row_Number() First_Cell = InputBox("Enter the First Cell of the Range: ") Row_Number = ...

VBA Range with Variable Row Number in Excel – 4 Examples

Find the Last Row with Data in a Range Using Excel VBA Macros – 7 Methods

Aug 9, 2024

This is the sample dataset. Opening the VBA Editor Press Alt+F11. Select Insert > Module. Method 1 - Use of the Range.End ...

Find the Last Row with Data in a Range Using Excel VBA Macros – 7 Methods

How to Concatenate Apostrophe in Excel: 6 Easy Methods

Jul 3, 2024

Method 1 - Using Ampersand Operator (&) to Concatenate Apostrophe Steps: Type the following formula in cell D5. ...