View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default using text from a cell in header

Look at the rows to repeat at the top setting in the the 3rd tab of the page
setup dialog.

If you want to use a different cell at the top of each page in a worksheets,
then you will have to print each page separately and either put the value on
the page or change the value in the rows to repeat location.

--
Regards,
Tom Ogilvy

"Emiel" wrote in message
...
Does anybody have a clue if and how I can use the text from a cell in the

first line of each page in the header?

For example:
Page 1: A1
Page 2: A50
Page 3: A100
etc.

Thanks in adance.

Emiel (Holland)