Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional printing at top of page
I want the words "(continued from previous page)" to be
printed at the top** of each page EXCEPT page 1. (My data is always 2 or 3 pages.) But, after my macro runs, I never know WHERE the top of the second or third page will be because the data/results are different every time I run the macro. I already use the "rows to repeat" option for something else, but that wouldn't work anyway because that's for rows, not for specific words. Is there some kind of "conditional print at top of page" at which I can print my desired words? ** Actually, I don't want it to print at the top of the page ... I want it to print just under the rows that appear as a result of my defining the "rows to repeat" function in the Sheet tab within Page Set-up. So, at the risk of repeating ... I want the words "(continued from previous page)" to appear AFTER the "rows to repeat" data but before the data/results for that page. Thanks, in advace. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
Printing Headers on only first page and Footers on only last page | Excel Discussion (Misc queries) | |||
Printing multiple page worksheets on 1 single page | Excel Discussion (Misc queries) | |||
Printing second page if data overruns, otherwise print first page | Excel Programming |