Macros & Excel VBA Archives - Page 2 of 10

VBA to Remove Characters from String in Excel (7 Methods)

Dec 1, 2021 Macros & Excel VBA

Sometimes we need to remove certain characters from strings of a large dataset in Excel. Implementing VBA macro is the most effective, quickest, and ...

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

Dec 1, 2021 Excel Formulas

In this article, I’ll show how you can count if a cell contains text in Excel. I’ll show you to count the number of cells that contain texts, as well ...

Delete Multiple Rows in Excel with VBA (4 Ways)

Nov 29, 2021 Macros & Excel VBA

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

VBA Macro to Delete Row if Cell Contains Value in Excel (2 Methods)

Nov 29, 2021 Macros & Excel VBA

Sometimes we need to remove certain data from a huge dataset in Excel. When the cells in the dataset are carrying values, then we should be really ...

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

Nov 28, 2021 Macros & Excel VBA

Today I’ll show you how can count rows with VBA in Excel from any data set. I’ll show you how can count rows from a specific range, from a selected ...

How to Remove First Character in Excel (6 Methods)

Nov 28, 2021 Excel Formulas

We often need to remove the first character from a cell or a range of cells while working in Excel. Today I’ll show you how you can remove the first ...

How to Use Macro to Delete Rows Based on Criteria in Excel (3 Ways)

Nov 29, 2021 Macros & Excel VBA

While working in Excel, you can use a Macro to delete rows based on criteria. Today I’ll show you how you can use a Macro to delete rows based on ...

How to Use VBA to Delete Empty Rows in Excel

Nov 29, 2021 Macros & Excel VBA

Today I’ll show you how you can use VBA to delete the empty rows in Excel from your data set. Download Practice Workbook Delete Empty Rows ...

How to Delete Multiple Rows in Excel with Condition (3 Ways)

Nov 30, 2021 Excel Basics

While working in Excel, we sometimes have to delete multiple rows from a data set with a given condition. Today I’ll show you how to delete multiple ...

How to Auto-Update Current Time in Excel (With Formula and VBA)

Nov 28, 2021 Excel Basics

While working in Excel, we often have to enter the current date and time in a cell for various purposes and auto-update them. Today I’ll show you how ...

How to Create a Custom Formula in Excel (A Step-by-Step Guideline)

Nov 3, 2021 Excel Formulas

While working in Excel or making custom worksheets for business analysis, we may need to create a custom formula of our own. Despite all the ...

How to Transpose in Excel VBA (3 Methods)

Nov 28, 2021 Macros & Excel VBA

One of the most important and widely used activities that we have to accomplish while working in Excel is to transpose a data set. Today I’ll show ...

How to Merge Cells in Excel Vertically Without Losing Data

Nov 30, 2021 Excel Basics

One of the most important and widely used tasks that we have to accomplish while working in Excel is to merge cells vertically without losing any ...

Excel VBA to Copy Multiple Sheets to New Workbook

Nov 4, 2021 Excel Basics

We often have to copy one or multiple sheets from one workbook to a new workbook while working in Excel. Today I’ll show you how you can copy ...

How to Insert Rows Automatically in Excel (3 Ways)

Nov 1, 2021 Excel Basics

While working in Excel, we may need to insert rows automatically in our dataset. Excel provides some features to do that job. Today, in this article, ...