LinkBack URL
About LinkBacks
Rename Sheets Test.xlsm
This is a pretty simple problem I think but because of my limited knowledge regarding all things VBA I find myself unable to proceed. The attached sheet should make it easy to see what my problem is. Thanks!
Rename Sheets Test.xlsm
This is a pretty simple problem I think but because of my limited knowledge regarding all things VBA I find myself unable to proceed. The attached sheet should make it easy to see what my problem is. Thanks!
Try:Put the macro in a regular module not in a Worksheet module as you had it in your attached file.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hello and thanks for replying,
I need this code to be activated by Command Button. Do I add the code to the button's module?
You can either put the code into the buttons module or put the code in its own module and call it from the button.Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
Hello Stnkynts,
Your code gets me very close to what I need. However, I need for it to skip sheets when a cell in range A4:A14 is skipped, so I have 11 sheets I want to potentially rename, and Range ("A4:A14") is 11 cells, if the A6 & A7 cells are blank, I need for Sheets 5 & 6 to not be renamed, but since A8 is populated again I would need Sheet 7 to be renamed. I hope this makes sense to you. Thanks!
Please Login or Register to view this content.
Originally Posted by stnkynts
Please Login or Register to view this content.
PERFECT! Thankyou so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks