worksheet page numbers
 

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

On Mon, 25 Apr 2005 07:02:07 -0700, Anne S <Anne
wrote:

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

Thanks
Anne

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)

--
Regards,
Zack Barresse, aka firefytr


"Anne S" <Anne wrote in message
...
Is there an easy way to put page numbers on worksheets? The MS
instructions
did not work.

Thanks
Anne