How to increment page number in a cell of worksheet
 

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.

How to increment page number in a cell of worksheet
 

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" wrote:

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.

How to increment page number in a cell of worksheet
 

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......

"מיכאל (מיקי) אבידן" wrote:

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" wrote:

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.