worksheet page numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anne S - 25 Apr 2005 15:02 GMT

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

Thanks
Anne

Reply to this Message

Gord Dibben - 25 Apr 2005 21:34 GMT

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

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

Reply to this Message

zackb - 27 Apr 2005 01:00 GMT

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)

Signature

Regards,
Zack Barresse, aka firefytr

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

Reply to this Message