Macros & Excel VBA

Excel VBA: Count Rows with Specific Data (8 Examples)

We use Excel VBA code to perform work by simply clicking a single button only. In this article, we will discuss how to count rows with specific data ...

Excel VBA: How to Find and Replace Text in Word Document

If you are looking for some of the effective and easiest ways to find and replace text in a Word document using Excel VBA then you will find this ...

How to Find and Replace from List with Macro in Excel (5 Examples)

Sometimes, we have to find certain text or text strings or numerical values in our Excel worksheet and replace it with our desired input. We can do ...

How to Use Dynamic Range for Last Row with VBA in Excel (3 Methods)

The VBA Dynamic Range provides you the opportunity to use the same code for newly added or removed data while working with a larger dataset. However, ...

Create Dynamic Named Range with VBA in Excel (Step-by-Step Guideline)

We can refer to a certain range of cells in the Excel worksheet by using the Define Name feature. But, we constantly need to add new data or update ...

Excel VBA to Find and Replace Text in a Column (2 Examples)

In Microsoft Excel, a VBA macro can solve a lot of problems with ease. The problem you were solving with complexity, VBA will do that with less time. ...

VBA to Remove Time from Date in Excel (3 Methods)

Sometimes there are data in an Excel worksheet that consists of both time and date. Occasionally, we want to get rid of only time or date from that ...

Data Validation Drop Down List with VBA in Excel (7 Applications)

Data validation dropdown lists are a very useful feature to perform various Excel related tasks. Implementing VBA is the most effective, quickest, ...

Default Value in Data Validation List with Excel VBA (Macro and UserForm)

While working with data validation list (s) in Excel or VBA, we often need to set a default value. In this article, I’ll show you how you can set a ...

Excel VBA: First Day of Month (3 Methods)

While working with Excel, sometimes we need to know the first day of the given date or month. But there is no direct function or formula in Excel to ...

How to Get the Last Day of Month Using VBA in Excel (3 Methods)

This article illustrates 3 different methods to get the last day of the current, past, or future month from a specific starting date using VBA code ...

Excel VBA: Count Unique Values in a Column (3 Methods)

Counting the unique values in a column is one of the major features that’s used quite often while working in both Excel and VBA. In this article, ...

Excel VBA Examples with Cell Reference by Row and Column Number

The cell is the smallest part of an Excel worksheet. And the range is a collection of the cells. We can represent a cell in different ways. Usually, ...

Excel VBA: Filter Date before Today (With Quick Steps)

In Microsoft Excel, working with dates is a pretty common thing. And filtering those dates is also a day-to-day task for a lot of Excel users. Now, ...

Excel VBA: Count Rows in Named Range (4 Methods)

We can count rows in a named range by using workbook functions or conditional formatting but if we work with a large amount of data then using VBA ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo