Renaming Multiple Tabs
I need to rename many tabs quickly and numberically (1, 2, 3, etc.). Is there
a faster way than just right-clicking and renaming each worksheet? |
Renaming Multiple Tabs
Run this macro
Sub RenameTabs() For i = 1 To Sheets.Count Sheets(i).Name = i Next End Sub "britt@wjg" wrote: I need to rename many tabs quickly and numberically (1, 2, 3, etc.). Is there a faster way than just right-clicking and renaming each worksheet? |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com