Macros & Excel VBA

Macro to Compare Two Columns in Excel and Highlight Differences

Sometimes we need to highlight some data in Excel to have a better understanding of our dataset. Implementing VBA macro is the most effective, ...

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

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to ...

How to Find and Replace Using VBA (11 Ways)

If you are looking for some of the easiest ways to find and replace using VBA, then you are in the right place. In this article, you will get to know ...

How to Remove Macros from Excel (5 Suitable Ways)

Removing VBA Macros is easier if you know the right methods. In this article, I’ll show you how 5 suitable ways to remove Macros from a file in ...

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

Sometimes for easy calculation, we need to split an Excel sheet into multiple sheets based on rows. In this article, we are going to learn how to do ...

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

Implementing VBA is the most effective, quickest and safest method to run any operation in Excel. In this article, we will show you how to check if a ...

How to Edit Macros in Excel (2 Ideal Methods)

Microsoft Excel's VBA Macro is one of the tools that can perform any operation on any worksheet with ease. It can save a lot of time also. VBA Macro ...

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

If you are looking for some of the easiest ways to find an exact match using VBA, then you will find this article useful. So, let’s get started with ...

How to Find within a Range Using VBA in Excel

In this article, I’ll show you how you can find a text within a range with VBA in Excel. You’ll learn to find the text using both exact and partial ...

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

For one thing, Excel by default stores time and dates in serial numbers which are converted to dates only by changing the formatting of the cells. ...

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

Implementing VBA is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to find ...

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

Working with strings in Microsoft Excel is a common scenario. You can find strings from a cell easily by a lot of formulas. Sometimes, it takes a ...

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

Fortunately, if you are looking for some of the easiest ways to find substring using VBA, then you are in the right place. After going through this ...

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

In Excel VBA, you can use different methods to find the last row. In this article, I am going to explain different methods of to find last row in ...

FindNext Using VBA in Excel (2 Examples)

If you are working with Microsoft Excel's VBA, you know how much time it can save. You may feel that VBA codes are complex to write. But once you ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo