Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Page Number of a cell
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 |
#2
|
|||
|
|||
Page Number of a cell
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). -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) wrote in message oups.com... 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 |
#3
|
|||
|
|||
Page Number of a cell
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 Arvi Laanemets wrote: 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). -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |