Thread: Insert automatic page numbering into a cell, not a header or foote
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote