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

[Catherine D]

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

 

[Gord Dibben]

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