Renaming Multiple Tabs

B

britt@wjg

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?
 
S

Sheeloo

Run this macro
Sub RenameTabs()
For i = 1 To Sheets.Count
Sheets(i).Name = i
Next
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif to multiple tabs 1
Can I sort worksheets based on the tab name? 2
rename worksheet tabs 2
Serious Excel Challenge 0
How do I combine multiple tabs into one? 2
CAN EXCEL AUTO DATE ADDED WORKSHEETS? 1
Macro recorded... tabs & file names changed, macro hangs 3
Check for two sheets. Add or subtract as necessary. 2

Top