LinkBack URL
About LinkBacks
Newbie....How do I sequentially number tabs 1-50 for example without having to manually rename each one?
Newbie....How do I sequentially number tabs 1-50 for example without having to manually rename each one?
if the sheets are already created something like this should work
you can change the 1 to 8 to anything you want....
Sub testing() For x = 1 To 8 Sheets(x).Name = x Next x End Sub
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Nice trick! Is there a way to exclude a first summary tab and renumber all the others following 1-50?
Maybe:
Sub khorner() Dim i As Long For i = 1 To 50 Sheets(i).Name = i Next i End Sub
Your method works, too! This is great. However, is there a way to exclude a first summary tab and renumber the others that follow sequentially 1-50?
sure
Sub testing() For x = 2 To 50 Sheets(x).Name = x Next x End Sub
Awesome! Thanks a lot! This will solve my dilemma nicely!
If this has been completed to your satisfaction, please set the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be us...just a thought...
thanks -- and I'm glad we could help....have a great day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks