ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rows to Repeat at Top (https://www.excelbanter.com/excel-discussion-misc-queries/60237-rows-repeat-top.html)

Karen

Rows to Repeat at Top
 
Is there a way to concal repeating rows (when printed) on the last page of
your worksheet?

Dave Peterson

Rows to Repeat at Top
 
Maybe you could record a macro when you print the first x - 1 pages and then
change the rows to repeat at top and print the last page.

Ron de Bruin has sample code that you could modify at:
http://www.rondebruin.nl/print.htm#Header

Karen wrote:

Is there a way to concal repeating rows (when printed) on the last page of
your worksheet?


--

Dave Peterson


All times are GMT +1. The time now is 01:22 AM.

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