Macros & Excel VBA Archives - Page 33 of 50

How to Find and Replace Text in Word Document Using Excel VBA (5 Methods)

Jul 21, 2024

Method 1 - Using Excel VBA to Find and Replace a Text String in a Word Document Open the Word document that contains the list of products. ...

How to Find and Replace Text in Word Document Using Excel VBA (5 Methods)

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

Jul 26, 2024

Example 1 - Find and Replace a Word from a List with Excel Macro In the following dataset, we want to find the product Cable and replace it with TV. ...

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

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

Jul 12, 2024

Why Do You Need a Dynamic Range We have a simple dataset with Quantity, Unit Price, and Sales of some Items. We want to find the average, sum, ...

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

Excel VBA to Find and Replace Text in a Column: 2 Methods

Jun 21, 2024

Method 1 - Use the Replace Method of VBA to Find and Replace Text in a Column A. Build the Code Open VBA Editor Press Alt+F11 on your ...

Excel VBA to Find and Replace Text in a Column: 2 Methods

Using VBA to Remove Time from a Date in Excel – 3 Methods

Aug 12, 2024

The above image is the sample dataset. Method 1 - Embed VBA to Delete Time from Dates in a Column in Excel Remove time in ...

Using VBA to Remove Time from a Date in Excel – 3 Methods

How to Create a Data Validation Drop-Down List with VBA in Excel (7 Methods)

Jun 18, 2024

Method 1 – Embedding VBA to Create a Data Validation Drop-Down List Steps: Press Alt + F11 or go to the tab Developer -> Visual Basic to ...

How to Create a Data Validation Drop-Down List with VBA in Excel (7 Methods)

How to Calculate the First Day of the Month Using Excel VBA (3 Methods)

Jul 26, 2024

Dataset Overview Suppose we have an Excel worksheet containing information about a sales representative named Emma from the Armani group. Her ...

How to Calculate the First Day of the Month Using Excel VBA (3 Methods)

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

Jul 6, 2024

Overview of the Code Sub Number_of_Values_that_Appear_Only_Once_1() Set Rng = Range("C4:C15") Count = 0 For i = 1 To ...

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

Excel VBA with Cell Reference by Row and Column Number – 11 Examples

Aug 9, 2024

This is the sample dataset. Example 1 - Insert a Value in a Single Cell Using Reference by Row and Column Number with Excel VBA Step 1: ...

Excel VBA with Cell Reference by Row and Column Number – 11 Examples

How to Use Excel VBA to Create Data a Validation List from Array

Jul 5, 2024

The salespersons' dataset has their working region and selling products. We will create a data validation list for the Region and Product ...

How to Use Excel VBA to Create Data a Validation List from Array

Excel VBA: Cell Reference in Another Sheet – 4 Methods

Aug 3, 2024

This is the sample data set. Method 1- Reference Cells in Another Sheet with Excel VBA Copy the data in D5 in ‘Sheet2’ to ‘Sheet1’ Step 1: ...

Excel VBA: Cell Reference in Another Sheet – 4 Methods

How to use Excel VBA with an Advanced Filter – 6 Examples

Aug 15, 2024

This is the sample dataset. Example 1 - Use Excel VBA to Filter Data in the Current Location Set the criteria in B16:E17. Step 1: ...

How to use Excel VBA with an Advanced Filter – 6 Examples

Excel VBA: Count Characters in Cell: 5 Methods

Jun 6, 2024

Method 1 - Use of VBA Len Function to Count Characters in a Cell in Excel The LEN function in VBA Excel returns the number of characters in a text ...

Excel VBA: Count Characters in Cell: 5 Methods

How to Count Filtered Rows in Excel with VBA (Step-by-Step Guide)

May 18, 2024

Suppose you have the following dataset. Step 1 - Apply a Filter to the Dataset Select any cell of your dataset. Go to the Data ...

How to Count Filtered Rows in Excel with VBA (Step-by-Step Guide)

VBA to Check If CheckBox Is Checked in Excel: 3 Ways

Jul 5, 2024

Method 1 - Embed VBA Macro to Check If a CheckBox Is Checked with a Numeric Value in Excel Add a checkbox to examine whether the checkbox is checked ...