VBA code to Copy and Rename Worksheet

[LampCommandr]

Hey folks,

I am fairly new to VBA coding in Excel and I am trying compile a script that will allow me to copy an existing worksheet and rename it based off of values referenced in the range A2:A54 in another worksheet.

Here is an overview:

1. Worksheet to copy - "Template"
2. Worksheet with range for renaming - "Weekly Overview"
3. Cell range for renaming - "A2:A54"
4. Values in the cells are as follows - A:2 = 1/4/10, A:3 = A2+7, A:4 = A3+7, etc.
5. The issue I am having is the fact that the values in the cells are formatted as date and have a 7 day increment (basically, each cell lists the first day of each week)
6. I would like to keep the formatting "MM-DD-YYYY" in the tab name

This is what I have so far:
--------------------

Please Login or Register  to view this content.

--------------------

This currently fails because of the "/" in the date format even though I have a custom format of "MM-DD-YYYY" on the cell range.

Any help with this one would be greatly appreciated.

[davesexcel]

If you have a date in A1 here is what you could use to name the sheet with that date

Please Login or Register  to view this content.

Make it work for your code