How to restrict the TitleRow only for a specific range of rows?

O

Oscar

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 ?
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Button for every sheet one new email 0
Multiple graphs 1
Macro Print Range Problem - Rows Cut Off (Upgraded From Excel 2003 to2007) 1
PrintTitleRows 4
Post my named ranges in column A 10
Method to automate page numbers on single worksheet 1
Excel 2013 Merge Data 2
Create Range of Visible Rows only 2

Top