Macros & Excel VBA

Calculate Number of Days Between Two Dates with VBA in Excel

While working with dates with VBA in Excel, we often have to calculate the number of days between two dates. In this article, I’ll show you how you ...

How to Copy Worksheet to Another Workbook Using VBA

For illustration, we have a sample workbook named "Source" with three worksheets "List-1", "List-2", and "List-3". We will copy these ...

How to Delete Column and Shift Left Using VBA in Excel (5 Methods)

While working with a large Microsoft Excel, sometimes unnecessary data will appear in front of us, and we need to delete those unnecessary data in ...

How to Delete Unfiltered Rows in Excel Using VBA (4 Ways)

Sometimes, when while working with a dataset we want to filter data and only want the visible cells and delete unfiltered rows in Excel. In this ...

How to Remove Duplicate Rows Based on One Column Using Excel VBA

If you are trying to remove duplicate rows based on one column with the help of VBA Excel for your dataset, then you will find this article helpful. ...

VBA to Copy Worksheet to Another Workbook and Rename: 5 Methods

Method 1 - Embed VBA to Copy One Worksheet to Another Excel Workbook and Rename It Steps: Press Alt + F11 on your keyboard or go to the tab ...

Macro to Copy and Paste from One Worksheet to Another (15 Methods)

We'll use the following sample dataset to showcase how you can copy and paste values between worksheets. Method 1 - Embed VBA Macro to ...

How to Delete Duplicate Rows in Excel Using VBA (8 Methods)

Dataset Overview To explain these methods, we will use a dataset that contains information about the department, working hours, and the salary of ...

How to Paste From Clipboard to Excel Using VBA

Method 1 - Paste from Clipboard in Single Cell Using VBA Before applying this method, you need to activate Microsoft Forms 2.0 Object Library for ...

How to Delete Multiple Columns by Number Using VBA in Excel (4 Ways)

In this article, we’ll illustrate how to delete multiple columns by number using VBA code in Excel with 4 different examples. As deleting columns is ...

How to Copy Sheet to End in Excel Using VBA (6 Methods)

We have a workbook with two worksheets, NewYork and Boston. The name of the workbook is "Excel VBA Copy Sheet to End". We have another workbook named ...

How to Filter and Delete Rows with VBA in Excel – 2 Methods

The sample dataset showcases Salesman, Product, and Net Sales of a company. Method 1 - Filtering the Visible Rows and Deleting them with ...

Excel VBA to Count Duplicates in a Column (A Complete Analysis)

While working with VBA in Excel, we often need to count duplicates in a column in a worksheet. In this article, I’ll show you how you can count ...

How to Delete Selected Rows with Excel VBA (Step-by-Step Guide)

This article shows how to delete selected rows in Excel with VBA in the simplest possible way. Surely you can add or delete rows or columns manually ...

Excel VBA to Copy Formula with Relative Reference (A Detailed Analysis)

While working with VBA in Excel, we often need to copy formula (s) with relative cell reference (s) from one range to another range. In this article, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo