ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Repeat Rows but not on every page! (https://www.excelbanter.com/excel-worksheet-functions/258783-repeat-rows-but-not-every-page.html)

AndreaW

Repeat Rows but not on every page!
 
Is it possible to set the repeat for just a certain number of pages, not all?
Example: I want to repeat $2:$2 on page 1 through 6 but I don't want the
repeat on pages 7 through 10. Is there a way to define this?

Luke M[_4_]

Repeat Rows but not on every page!
 
Setup a custom print macro that prints pages 1-6 with the repeated row, and
pages 7 - 10 w/o repeat?
(You can record this macro yourself)

--
Best Regards,

Luke M
"AndreaW" wrote in message
...
Is it possible to set the repeat for just a certain number of pages, not
all?
Example: I want to repeat $2:$2 on page 1 through 6 but I don't want the
repeat on pages 7 through 10. Is there a way to define this?





All times are GMT +1. The time now is 11:33 AM.

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