I want a button that can rename worksheets based on their name. I am thinking it would need a string compare but I'm not sure how to do that.
The button should rename anything named "Node (then a number)" or "Sheet(then a number)" and then rename them to "Node (then a number)" based on the order they're placed in the workbook.
Try something like this.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
It is only renaming the sheet* and not the Node*. Also, if I have to reorganize in the future, and the order becomes Node 2, Node 5, Node 1, Node 3, Node 4... will I get a rename error?
It works for me with both "Node" sheets and "Sheet" sheets.Originally Posted by acrawl
It won't give you a name error because it renames everything as Nodetemp# then renames them as Node# in their placement order.
Oh you're right! Sorry I had accidentally deleted something in the code. Thank you very much!!!
You're welcome. Glad it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks