![]() |
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