LinkBack URL
About LinkBacks
Hi!
In my workbook, I have several sheets named:
...and so on.HTML Code:
I want to create a macro or code that will take out the "_OTHER" from all the sheets so the sheets name would look like:
HTML Code:
THANKS! for all the help
Hi!
In my workbook, I have several sheets named:
...and so on.HTML Code:
I want to create a macro or code that will take out the "_OTHER" from all the sheets so the sheets name would look like:
HTML Code:
THANKS! for all the help
Please Login or Register to view this content.
Last edited by davegugg; 07-27-2010 at 12:04 PM. Reason: Enforce the sheet name to UCase just in case... ; )
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
[edit: too slow - removed dupe code - you might want to enforce the sheet name to UCase just in case...]
Pending complexity of file you might want to toggle manual calc as a rename will trigger recalculations as necessary.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Try this out
EDIT: OMG... I must be very sluggish when it comes to VBA (((Please Login or Register to view this content.
Last edited by contaminated; 07-27-2010 at 12:04 PM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Try this:
RegardsPlease Login or Register to view this content.
Contaminated, your code worked PERFECTLY!!
THANKS everyone for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks