How to increment page number in a cell of worksheet

[Zubair]

I have a problem regarding page numbers in a worksheet. The position of page
number in the cell is such that page number cannot be provided through header
or footer.

Can you guide me about how can I increment page numbers in a cell.

 

[מיכ×ל (מיקי) ×בידן]

This is a very unreliable workaround.
Declare col. "A" to be an Helper-Column.
In Cell A1 type the following formula and copy down to the end of your data.
Col. A Cells should, now, present the page number.
Pull out one of each, in a "page", to another column in order to present the
page number.
You may fine-tune, the formula, by slightly changing the 55
*** Hide column "A" ***
=IF(MOD(CELL("row",B1),55)=0,CELL("row",B1)/55,INT(CELL("row",B1)/55)+1)
Micky

 

[Zubair]

My worksheet is such that there is a panel in the top, that contains a cell
in the right in cell "BY3". Page number is incrementing during printing as
the panel is fixed and the worksheet is going on to page 1, 2, 3......