Delete duplicate records using VBA in Microsoft Excel

In this article, we will create a macro to remove duplicate records from the data. Raw data consists of employee data, which includes Name, Age and G...

how to extract a list of all the files and folders within a Windows OS folder onto Excel

We are working on many files & folder in Windows PC or laptop & there are chances that we may end up adding or deleting files & folders re...

Split data in a sheet by specific number of rows using VBA in Microsoft Excel

In this article, we will create a macro to split data by specific number of rows. We have raw data in sheet “RawData”. We want to split this data...

Create hyperlinked sheet list

How about having a list of sheets each being hyperlinked to their respective sheet name in the workbook?  Well, this can be done with the following c...

Fill a ListBox control with values from closed workbook using VBA in Microsoft Excel

In this article, we will fetch data from closed workbook to List box in userform using VBA. Raw data for this example is in range A2:B10 on “23Samp...

Copy a column or columns from each sheet into one sheet using VBA in Microsoft Excel

Sometimes, it becomes a routine work to copy data from multiple sheets for the same column. This step can be avoided using automation. If you want to ...

Mail the Activeworkbook using VBA in Microsoft Excel

Sub Mail_workbook() ActiveWorkbook.SendMail "ron@debruin.nl", _ "This is the Subject line" End Sub If you want to ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube