Sunday 15 October 2017

Hints - Microsoft Excel - Naming Tabs for Weeks





If you instead need a way to create worksheets that show the ending date of each week for a year, then a different macro is needed.



This  macro asks you for a beginning date. It then uses that date to start naming the different worksheets in the workbook.

 If a value  that cannot be translated to a date, then the macro will generate an error.


Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London


No comments:

Post a Comment