I am trying to copy the active sheet (that acts as a template) and create a new sheet that is renamed based on a cell value.
The code I currently am using works except that it drops the first few zero's from the name.
For example: The cell value equals 00010, when I copy and rename the tab, I get 10. I would really like to keep the formatting the same.
The formatting for the cell is for zip code.
Any advice?
Thanks
Here's my code:
Please Login or Register to view this content.
Bookmarks