excel page numbers
 

Hi Steve,

I'm not sure if you mean "Sheets" or "Pages". If Pages I don't see how these
details only in the top row help unless each sheet prints as one page, but I
may be missing something.

Whatever, maybe the old xl4 functions might be of use to you. Find and
download a copy of "Macrofun.hlp" or "Macrofun.zip" and look in particular
at the GET.DOCUMENT and GET.WORKBOOK functions

To use these in cell formulas they need to be defined as formulas, eg
Defined Name =formula
Total_Sheets =GET.WORKBOOK(4)
TotalPrintPages =GET.DOCUMENT(50)
PrintHeader =GET.DOCUMENT(54)

Then in a cell type "Total_Sheets" without quotes

It might be possible to return current sheet as a number.

Regards,
Peter T

"Steve J. Vaughan" wrote in
message ...
I have been asked to create a spreadsheet with the first three rows
repeated
on every page. However in one of the cells in the first three rows there
is a
requirement for the page number and number of pages . I know this is
normally
set in the page header but the layout requires it in a specfied cell.

Is there away of getting the &[page] and &[pages] data into a cell, and
will
it work when printing?