Macros & Excel VBA Archives - Page 46 of 60

Macros & Excel VBA

Macro to Insert Row and Copy Formula in Excel (2 Methods)

Jul 20, 2022 Excel Basics 6

In this article, I’ll show you how you can develop a Macro to insert a row and copy a formula using VBA in Excel. You’ll learn to insert one or more ...

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

Nov 28, 2022 Advanced Excel

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 ...

Change Font Color Based on Value of Another Cell in Excel

Jan 26, 2023 Excel Basics

Changing the font color of a dataset is one of the essential tasks of Microsoft Excel. We do it to have a clear and attractive look at our dataset. ...

Macro to Insert Multiple Rows in Excel (6 Methods)

Jul 20, 2022 Macros & Excel VBA 2

Sometimes we need to modify our large dataset in Excel by inserting rows based on certain conditions. Implementing VBA macro is the most effective, ...

Excel Align Matching Values in Two Columns

Nov 28, 2022 Excel Formulas 2

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 ...

How to Concatenate Range with Separator Using VBA in Excel

Jan 24, 2023 Excel Basics

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 Change Text Color with Formula in Excel (2 Methods)

May 18, 2022 Advanced Excel

Changing text color is a very important task in Excel. It helps in many ways to highlight and analyze data. We can do it manually but there is no ...

How to Remove Timestamps from Date in Excel (4 Easy Ways)

Jan 22, 2023 Excel Formulas

Working with Microsoft Excel is great fun. We usually work to process data and get information using MS Excel. When we collect data, we use date and ...

How to Delete Row Using VBA (14 Ways)

May 18, 2022 Macros & Excel VBA

If you are looking for some of the easiest ways to delete row using VBA, then you are in the right place. Let’s dive into the main article. ...

Excel VBA: Select Multiple Columns (3 Methods)

Jan 22, 2023 Macros & Excel VBA

Selecting multiple columns in Excel is a common task. We select numerous columns to perform various operations. You can pick multiple columns ...

How to Use VBA Range Based on Column Number in Excel

Jan 23, 2023 Advanced Excel 1

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 ...

Excel Macro to Add Row to the Bottom of a Table

Jan 23, 2023 Excel Basics 4

In this article, I’ll show you how you can develop a Macro to add a new row to the bottom of a table in Excel. You’ll learn to add an empty new row ...

How to Remove Hidden Double Quotes in Excel (6 Easy Ways)

Jul 17, 2022 Excel Basics

Every now and then we import data from external sources in Excel. In doing so, we come across various inserted characters among entries that cause ...

VBA to Remove Formulas in Excel Keeping Values and Formatting

Aug 10, 2022 Advanced Excel 2

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 ...

How to Clear Formula in Excel (7+ Methods)

May 18, 2022 Advanced Excel

Microsoft Excel is one of the most popular tools used for rigorous calculations. Numerous built-in functions make it easy to perform complex ...