mhenk
Well-known Member
- Joined
- Jun 13, 2005
- Messages
- 591
Hi there!
I have another stupid macro request.
I have 791 sheets, named "Table X.Y.Z", where X ranges from 1 to 4, Y ranges from 1 - 150, and Z ranges from 1-3.
I need to rename all of these sheets but nothing dramatic.
I need to change all the X's to X+3's.
So, every sheet titled "Table X.Y.Z" will become "Table X+3.Y.Z".
Obviously, this needs to start with the sheets labelled 4.Y.Z, otherwise there will be two workbooks with one name.
I have no problem sorting the sheets so that all the 4's come before all the 3's, etc, so a macro would work, but if someone could provide me some code to get started on renaming this block of sheets, it'd be much appreciated!
I have another stupid macro request.
I have 791 sheets, named "Table X.Y.Z", where X ranges from 1 to 4, Y ranges from 1 - 150, and Z ranges from 1-3.
I need to rename all of these sheets but nothing dramatic.
I need to change all the X's to X+3's.
So, every sheet titled "Table X.Y.Z" will become "Table X+3.Y.Z".
Obviously, this needs to start with the sheets labelled 4.Y.Z, otherwise there will be two workbooks with one name.
I have no problem sorting the sheets so that all the 4's come before all the 3's, etc, so a macro would work, but if someone could provide me some code to get started on renaming this block of sheets, it'd be much appreciated!