FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I have a macro that copies the current sheet and then clears out old data so I can update it, but I can't figure out how code it to rename the tab using the weekly sequence that I use (the naming convention is Wk 1, Wk 2, Wk 3, etc.). So when Wk 33 is copied, I would manually rename it to Wk 34, but I don't know how to code that. Can anyone help?
I have a macro that copies the current sheet and then clears out old data so I can update it, but I can't figure out how code it to rename the tab using the weekly sequence that I use (the naming convention is Wk 1, Wk 2, Wk 3, etc.). So when Wk 33 is copied, I would manually rename it to Wk 34, but I don't know how to code that. Can anyone help?