worksheet page numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks
Anne
 
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
 
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)
 
Back
Top