Excel - Autonumber tabs

Hi,

Please offer a method to autonumber the worksheet tabs - and what is the maximum number of tabs per workbook.

Example, I am using Excel 2007, and would like to autonumber the worksheet tabs from 100 - 200.

Thank you for all your efforts.
tahirihAsked:
Who is Participating?
 
TracyVBA DeveloperCommented:
>>What is the maximum number of tabs per workbook.
Sheets in a workbook is limited by available memory (default is 3 sheets)
  http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

To rename the sheets, see that attached code.
Sub RenameSheets()
        
    Dim myCounter As Integer
    Dim i As Integer
    
    myCounter = 100
        
    For i = 1 To Worksheets.Count
        Sheets(i).Name = myCounter
        myCounter = myCounter + 1
    Next

End Sub

Open in new window

Book1.xls
0
 
tahirihAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.