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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Worksheet page numbering 3
Insert Page Numbers on Worksheet in Excel 2007 6
converting PDF file to Word 5
Excel Fit to page print options in Excel 1
numbering pages in footer 1
Page numbers 3
Changing number sequence on different pages 1

Back
Top