Changing header text from one page to another

[Peter Facey]

My spreadsheet contains a large number of names and addresses, one per row.
When printing it, I want to throw a new page when the street name changes and
also to put the new street name into the page header.

I can easily run down the rows inserting page breaks when the street name
changes, but is there any way of changing the header text dynamically?

Two thoughts occurred:
* is it possible to execute a vba procedure during printing every time the
top or bottom of a page is reached (one can in Access)?
* is it possible to make the header text a function of a cell value on the
page about to be printed?

 

[Peter Facey]

Thanks. That's rather what I expected, but I just thought I'd ask.