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