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...

Show the time in hh:mm.sss format using VBA

In this article, we will create a macro to format the time in hh:mm.sss format. Raw data for this example consists of certain time values in column E...

Create day sheets of a month without weekends and holidays using VBA

In this article, we will create a macro to create a sheet for each weekday for the specified month of the specified year excluding all the dates speci...

Copy data having date between two defined dates to new worksheet using VBA

 In this article, we will create a macro to extract data from raw data worksheet to a new worksheet, based on the specified date range. Raw da...

Delete all cells with data from previous dates using VBA

In this article, we will create a macro to delete data of previous dates. This macro checks the data, keeps today’s data and deletes all the data fr...

Execute Command/Sub-Procedure Using VBA Timer

In this article, we will create a macro to call another macro or execute a command after defined intervals of time. To execute the macro, cli...

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.