Insert automatic page numbering into a cell, not a header or foote
 

Hello,

I would like to insert a pge number into a row to repeat at the top of each
page. We have developed a page "header" in the first rows of the worksheet
so that they are visible to non-saavy Excel users and would like the page
number to increment in one of the cells that repeat at the top of each
printed page.

I also want text in the cell so that it would print "page 1" in one cell
where 1 is actually &[page].

How do you do this?

Thanks, Catherine
--
BC, Canada

Insert automatic page numbering into a cell, not a header or foote
 

Have a look at the code on Ron de Bruin's site.

Adapt to suit.

http://www.rondebruin.nl/print.htm#same


Gord Dibben MS Excel MVP

On Thu, 10 Sep 2009 14:39:02 -0700, Catherine D
wrote:

Hello,

I would like to insert a pge number into a row to repeat at the top of each
page. We have developed a page "header" in the first rows of the worksheet
so that they are visible to non-saavy Excel users and would like the page
number to increment in one of the cells that repeat at the top of each
printed page.

I also want text in the cell so that it would print "page 1" in one cell
where 1 is actually &[page].

How do you do this?

Thanks, Catherine