worksheet page numbers

A

Anne S

Is there an easy way to put page numbers on worksheets? The MS instructions
did not work.

Thanks
Anne
 
G

Gord Dibben

Anne

Page numbers where?

Headers and Footoers when printing allow page numbers.

Which MS instructions?

More detail what you have tried and on "did not work" please.


Gord Dibben Excel MVP
 
Z

zackb

If you are referring to a worksheets Index in the workbook, you can make use
of this UDF ...

Function SheetNum(Optional celRef As Range) As Long
With Application.Caller.Parent
If celRef Is Nothing Then
SheetNum = .Index
Else
SheetNum = celRef.Parent.Index
End If
End With
End Function

Enter as ...

=SheetNum()
or
=SheetNum(A1)
or
=SheetNum(Sheet2!A1)
 
Top