Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing header text from one page to another
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing header text from one page to another
Thanks. That's rather what I expected, but I just thought I'd ask.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing header text from one page to another | Excel Programming | |||
Changing the color of header and footer text | Excel Discussion (Misc queries) | |||
Automate Page Header Text | Excel Programming | |||
changing page numbers in repeated header | Excel Discussion (Misc queries) | |||
Changing (Part of) Header Without Changing Footer or Rest of Header | Excel Programming |