Macros & Excel VBA

Using a Macro to Compare Two Columns and Highlight the Differences in Excel – 2 Methods

Method 1 - Using a VBA Macro to Compare Two Columns and Highlight the Differences in Excel This is the sample dataset. Steps: Press Alt ...

How to Merge Multiple Excel Files into One Sheet by VBA (3 Examples)

We have 3 Excel files - File1, File2, and File3 - which we are going to merge into one sheet or in one workbook. Remember: The files ...

How to Find and Replace Using VBA (11 Ways)

  Download the Workbook VBA Find and Replace. xlsm How to Find and Replace Using VBA - 11 Ways We will use the following table ...

How to Remove Macros from Excel – 5 Methods

This is an overview:   Method 1 - Selecting and Removing Macros using the Macro Dialog Box in Excel Step 1: Opening the Macros ...

How to Split a Sheet into Multiple Sheets Based on Rows in Excel

Observe the GIF. The sample dataset (B4:C10) showcases  employees and their working hours in Sheet1. To split the sheet into multiple ...

How to Check If a String Contains Another String in Excel Using VBA (6 Methods)

Method 1 - Checking for Substrings Open the Visual Basic Editor by pressing Alt + F11 or navigating to the Developer tab and clicking on Visual ...

How to Edit Macros in Excel (2 Ideal Methods)

Here's an overview of using the Macros option to edit macros in a sheet. How to Unhide a Macro in a Personal Workbook Your macros can be ...

How to Find an Exact Match Using VBA in Excel (5 Easy Ways)

Suppose you have the following dataset: Method 1 - Find an Exact Match in a Range of Cells Steps: Press Alt+F11 on your keyboard to ...

How to Find a text within a Range Using VBA in Excel – 4 Methods

The sample dataset contains Book Names, Authors, and Prices. 1. Finding an Exact Match Within a Range with VBA in Excel (Case-Insensitive ...

How to Convert Serial Number to Date in Excel (7 Simple Ways)

Method 1 - Converting Serial Number to Date in Excel with Format Cells Option Steps: Select the C5:C16 cells >> Right-click to open the ...

How to Find a String with VBA in Excel (8 Examples)

Introduction to InStr Function in Excel VBA The InStr function in Excel VBA allows you to find the position of specific strings within a given text. ...

How to a Find a String in a Cell Using VBA in Excel (2 Ways)

Here, we have a dataset of some persons' names. All the names start with Mr. or Ms. Now, our goal is to find whether it is male or female by finding ...

How to Find Substring Using VBA in Excel (8 Easy Ways)

In this article, we will demonstrate how to use Excel VBA to find the position of a substring in a string, to extract data using this substring, and ...

How to Find Last Row Using Excel VBA (5 Easy ways)

There are 4 columns in the dataset representing sales information. These columns are Sales Person, Region, Product, and Price. We'll find the last ...

FindNext Using VBA in Excel (2 Examples)

Here is an overview of this article: What is FindNext in VBA? In VBA code, the FindNext method follows the Find method. It finds the next ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo