Is it possible to have sheet names automaticaly changed by text in a defined range of cells? Currently I'm changing sheet names manually.
I attached a file with I show what I need.
Thanks in advance!
Rgds, Robert
Is it possible to have sheet names automaticaly changed by text in a defined range of cells? Currently I'm changing sheet names manually.
I attached a file with I show what I need.
Thanks in advance!
Rgds, Robert
Try this.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
try this attached file
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi sktneer, thanks for your help! When executing the macro, nothing happens..(script placed in new module 1) Has the range in column B still to be added in the script?
The code will change the sheet names as per the cell values in the range B3:B5.
For detail see the attached sheet. Click the button "Click Here" to run the code.
Hi Naveed, I get a run time error 1004: Method 'Name' of Object" '_Worksheet' failed
In sub replace_sheet_name() the yellow arrow directs to:
.Name = MSht.Range("C" & i).
Hi Naveed, I get a run time error 1004: Method 'Name' of Object" '_Worksheet' failed
In sub replace_sheet_name() the yellow arrow directs to:
.Name = MSht.Range("C" & i).
Robert
in setup tab first click on get available sheet button next in column C enter the name which u want to replace then click on replace button
Naveed and sktneer, it works perfect! Many thanks!! Rgds, Robert
Last edited by Robert1311; 05-08-2014 at 05:42 AM.
Glad i could help you out
1. If the suggestion helps you, then Click * to Add Reputation and mention your comments
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Try this updated V2 , this will give u pop up if u missed to enter replace name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks