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...
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...
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...
In this article, we will use change event of worksheet to protect cells which contain formulas. Raw data consists of employee sales data, which inclu...
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...
The tip submitted by: Jay Shukla Some times we have a situation like: 1. Yahoo website www.yahoo.com 2. Google Website www.google.com So How...
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...
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.
