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