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