acruthi
12-07-2010, 10:55 AM
I have about 40 tabs and want to do a find and replace way to rename the tabs.
Eg:
Tab 1 = London Market Profile
Tab 2 = London Market Profile Detail
Change it to
Tab 1 = London Service Profile
Tab 2 = London Service Profile Detail
How can I get a macro to just find and replace Market to Service on the tab names for 40 tabs?
Thanks much!
Eg:
Tab 1 = London Market Profile
Tab 2 = London Market Profile Detail
Change it to
Tab 1 = London Service Profile
Tab 2 = London Service Profile Detail
How can I get a macro to just find and replace Market to Service on the tab names for 40 tabs?
Thanks much!