Hello,
I used the below to rename tabs in my excel file, but it renames every sheet with the specific cell number. I would like to only rename tabs that fall within my start and end sheets. Any help?
Sub UpdateSheetNames()
On Error Resume Next
For Each ws In Worksheets
ws. name = ws.range("A2").Text
Next ws
End Sub
Thanks,
yes.
The worksheets are indexed from left to right - as they appear in the user's view.
So, if you mean 'between' as in, the tabs for the worksheets are between the tabs of two sheets try:
NOTE: This code skips the start sheet name worksheet - so it will rename the sheets starting after the 'start sheet name'.
Please Login or Register to view this content.
Last edited by GeneralDisarray; 07-15-2015 at 12:01 PM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks