Page Number of a cell

[transferxxx]

Anybody can give me a formula which would show the page number of a
cell in which it is found as I would like to build a table of content.
Thxs

 

[Arvi Laanemets]

Hi

I don't think you can do this in universal way, because the number of page
depends on your printer, on page setup settings, on page design (are all
columns on single page or not), on the with of rows/columns on page, on
presence of hidden rows, on paper format, etc.

Of course, so long as you use the workbook only yourself, you can predefine
all this, and count rows on sheet with this setup. Then you can calculate
the sheet number from cell's row/column number(s).

 

[transferxxx]

Arvi,
Laurent Logne has a UDF under pagenum which is protected & can not be
attached to a file.
That's why I'm looking for the code for flexibility