ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can PrintTitleRows method be restricted to a region instead of the whole worksheet ? (https://www.excelbanter.com/excel-programming/329940-can-printtitlerows-method-restricted-region-instead-whole-worksheet.html)

Oscar

Can PrintTitleRows method be restricted to a region instead of the whole worksheet ?
 
I use the PrintTitleRows method for printing at top of each new page such as
ExcelSheet.PageSetup.PrintTitleRows= "$30:$30" . However, the last part of a
report which is printed should not display this toprow. Therefore I was
wondering whether there is a way or trick to have a region to which the
Titlerows can be restricted to.

regards,
Oscar




All times are GMT +1. The time now is 12:20 PM.

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