An Excel document is a Workbook.

Workbooks can have muliple worksheets.

Each worksheet can have multiple "pages" when printing.

What do you consider as a "tab"?

A worksheet or a printed "page"?

It seems to me you use the word "tab" to mean both.

Tabs(worksheets) don't have numbers except for a VBA codename number.

If you want a list of your sheetnames and corresponding codenames, run this
macro on a new sheet.

Sub CreateListOfSheetsOnFirstSheet()
Dim ws As Worksheet
For i = 1 To Worksheets.Count
With Worksheets(1)
Set ws = Worksheets(i)
.Cells(i, 1).Value = ws.Name
.Cells(i, 2).Value = ws.CodeName
End With
Next i
End Sub

If something else, wait for other responses or post back with a clearer
description of "tabs" and "numbers" and "pages" to help me out.


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 14:14:02 -0800, av8torsgal
wrote:

Is there a way to identify the page number of a tabbed worksheet without
manually inputting this information? I want the tabs to consecutively number
and adjust for deleted and/or added tabs. For example, I have a document
with multiple tabs that are named using text. When I am viewing or working
on a certain tab, I want to know the tab number in addition to the name of
the tab. I need this information when viewing or working on a tab rather
than when printing (so headers/footers will not work in this case).