Macros & Excel VBA

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

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)

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)

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)

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)

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)

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)

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

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)

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)

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)

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)

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

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

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)

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

ExcelDemy
Logo