How to restrict the TitleRow only for a specific range of rows?
How can I configure Excel such that the TitleRow
(ActiveSheet.PageSetup.PrintTitleRows = "$2:$2" ) which appears at the top of each page that is printed, should only be displayed for a specific range of rows, not for the entire worksheet ? |
How to restrict the TitleRow only for a specific range of rows?
To the best of my knowledge you can't... That is why (in the perfect world)
you only want to put one thing on one sheet. Keeps life simple and makes printing easier... "Oscar" wrote: How can I configure Excel such that the TitleRow (ActiveSheet.PageSetup.PrintTitleRows = "$2:$2" ) which appears at the top of each page that is printed, should only be displayed for a specific range of rows, not for the entire worksheet ? |
All times are GMT +1. The time now is 01:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com