Hello all,
is there any possibility to lookup whether a sheet tab is re-named and change it in the code accordingly automatic?
E.g. I change the sheet name "LogHistorie" to "example". I don't wanna change all by hand.....
tabname.JPG
Thank you already
Andi
The best way around this is to use the Sheet CodeName (the one NOT between brackets in the Project window)
That way it doesn't matter if you change the tabname.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Got it. Will do so in the future.
Thank you
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks