Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Macros & Excel VBA

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

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

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

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)

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

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

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)

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)

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)

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)

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

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

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)

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

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)

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

ExcelDemy
Logo