ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   conditional printing at top of page (https://www.excelbanter.com/excel-programming/303371-conditional-printing-top-page.html)

Dan Wasser[_2_]

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.


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com