Macros & Excel VBA

Unique Values in a Drop Down List with VBA in Excel (A Complete Guide)

In this article, I’ll show you how you can remove the duplicate values from a drop down list of a worksheet in Excel with the help of VBA and keep ...

Excel VBA: Dynamic Range Based on Cell Value (3 Methods)

This article illustrates how to define a dynamic range in Excel based on a cell value using VBA code. We’re going to explain 3 different examples to ...

How to Count Rows in Selection Using VBA in Excel

In general, a typical Excel workbook contains numerous rows. And these rows may have blank or non-blank entries. Excel VBA count rows in selection is ...

Excel VBA: Count Columns with Data (2 Examples)

When you have a small data table with a few columns, you can easily count them all. But for a large data table, it’s quite difficult to count all the ...

How to Find and Replace Multiple Values in Excel with VBA (3 Examples)

In this article, we will learn to find and replace multiple values in excel with VBA. VBA stands for Visual Basic for Applications. It is a ...

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

Excel VBA: Check If Multiple Cells Are Empty (9 Examples)

A Microsoft Excel file usually contains data in each cell. Sometimes some cells remain empty. To detect empty cells in Excel is tiresome work. We can ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo