Macros & Excel VBA Archives - Page 57 of 70

How to Use VBA to Remove Duplicates in Excel – 6 Examples

Aug 15, 2024

VBA Syntax to Remove Duplicates in Excel Generic Syntax Range.RemoveDuplicates(Columns, Header) Parameter Description ...

How to Use VBA to Remove Duplicates in Excel – 6 Examples

Cell Reference in Excel VBA (8 Examples)

Jun 15, 2024

We'll use a data set with the Book Name, Book Types, and Price of some books of a bookshop called Martin Bookstore. The data set lies in the range ...

Cell Reference in Excel VBA (8 Examples)

How to Use Year Function in Excel VBA (5 Suitable Examples)

Nov 11, 2025

The Year function in Excel VBA is under the Date and Time category functions. If we use it in a VBA code, it extracts the year from the date which we ...

How to Use Year Function in Excel VBA (5 Suitable Examples)

How to Use VBA MONTH Function in Excel (7 Suitable Examples)

Jul 30, 2024

The MONTH function falls under the Date or Time category. The MONTH function works both in worksheet and VBA Macros. It takes only one argument. ...

How to Use VBA MONTH Function in Excel (7 Suitable Examples)

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

Jul 4, 2024

In this article, we'll demonstrate how to use Excel's Advanced Filter in VBA. Excel Advanced Filter Overview Advanced Filter is a tool ...

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

How to Use EoMonth in Excel VBA (5 Examples)

Jul 7, 2024

Download Practice Workbook Uses of EoMonth.xlsm Overview of EoMonth Function in VBA ⏺ Function Objective Returns the serial number for ...

How to Use EoMonth in Excel VBA (5 Examples)

How to Use the VBA DatePart Function in Excel (7 Examples)

Nov 11, 2025

One of the most important and widely used functions that we encounter while working with VBA is the DatePart function of VBA. Today in this article, ...

How to Use the VBA DatePart Function in Excel (7 Examples)

How to Use VBA AutoFill in Excel (11 Examples)

May 21, 2024

Example 1 - Copy Information Down the Cells Using xlFillCopy Dataset: In Column B, cells B4 and B5 contain numbers 1 and 2. The cells are also ...

How to Use VBA AutoFill in Excel (11 Examples)

How to Format Date with VBA in Excel (4 Methods)

Jun 17, 2024

In the dataset, the same dates are in Columns B and C. We will format the date in Column C. Method 1 – Using VBA to Format Dates Steps: ...

How to Format Date with VBA in Excel (4 Methods)

Date Variable in VBA Codes (7 Uses of Macros with Examples)

Jul 8, 2024

Date Variable Format Requirements A date constant can be declared within hash signs (# #). It accepts two formats: m/d/yyyy - for example, ...

Date Variable in VBA Codes (7 Uses of Macros with Examples)

How to Get the Current Date in VBA – 3 Methods

May 15, 2024

Quick View: Method 1 - Getting the Current Date using the Date Function of VBA This is the code: Current_Date=Date() ...

How to Get the Current Date in VBA – 3 Methods

How to Use VBA DateValue Function in Excel (6 Examples)

Aug 6, 2024

Basics of VBA DateValue Function: Summary & Syntax Summary The Excel VBA DateValue function takes a value or an argument in string ...

How to Use VBA DateValue Function in Excel (6 Examples)

How to Use the Day Function in Excel VBA (3 Examples)

Nov 11, 2025

While working in Microsoft Excel Visual Basic for Applications (VBA), we may feel the necessity of using only the day value rather than the entire ...

How to Use the Day Function in Excel VBA (3 Examples)

How to Use the Mid Function of VBA in Excel (3 Examples)

Nov 11, 2025

One of the most important and widely used functions that we use while working with VBA in Excel is the Mid function of VBA. It takes a string as the ...

How to Use the Mid Function of VBA in Excel (3 Examples)

How to Convert Date from a String Using VBA – 7 Methods

Aug 9, 2024

This is the sample dataset. Method 1 - Using VBA to Convert Date to a Text String Step 1: Go to Developer Tab >> Visual Basic ...