Sequential Ordering on multiple tabs

[scottsoo9]

I have an Excel spreadsheet with multiple tabs. I want to number a cell in each tab sequentially from 1 to 484. There are 484 total tabs. So the first tab will be numbered 1 in a cell, the second tab will have number 2 in a cell, third tab will have number 3 in a cell, and so on till tab number 484 will have 484 in a tab.

Is there a way to do this so I do not have to enter each one manually? What would the formula be? Any help will be greatly appreciated. Thanks, Scott

 

[UniMord]

Enter in a Standard Module:

Function tabNum()
    'Returns the tab's number
    tabNum = Application.Caller.Parent.Index
End Function

Now, you can enter tabNum() on your sheet, and it'll give you the sheet's number.

 

[UniMord]

If you select all of your sheets, you can enter the formula once for all 484 sheets. Just remember to ungroup them before you do anything else!