Add page breaks to sorted data using VBA in Microsoft Excel

  In this article, we will create a macro to insert page breaks, based on a certain condition. Raw data consists agent wise data, which include...

Enter the Weekdays Mon – Fri in a Worksheet using VBA in Microsoft Excel

In this article, we will create a macro to extract the weekdays between two dates. In this example, we have to specify start date and end date before...

Replace text in a text file using VBA in Microsoft Excel

The macros below can be used to replace text in a text file, e.g. when you want to change a column separator in a text file before you import it int...

List and add days of months in a set period using VBA in Microsoft Excel

In this article, we will create a macro to list months between the defined period and also number of days in that particular month. It will also dis...

Distribute Data from a List of the day to day sheets using VBA

  In this article, we will create a macro to arrange data day-wise on multiple sheets. Raw data for this article consists day-wise sales data o...

Enter the holiday according to the Table in the holiday-list using VBA

Question: I have the EmployeeName, the HolidayStart and the HolidayEnd in a Worksheet. How can I color the holidays of each employee in the following...

Check if a VBProject is protected using VBA in Microsoft Excel

With the function below you can check if a VBProject is protected before you try to edit the project: Function ProtectedVBProject(ByVal wb As Workboo...

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