PrintTitleRows

[David Ponzio]

When I try to use the PrintTitleRows command in Excel 2002
(using the format Activesheet.pagesetup.printtitlerows
= "$1:$1", and I have tried other formats for the string
from Excel help and the book), the rows will not repeat on
the next page like they are supposed to. I have tried
recording it to a macro and referencing the macro through
the code, but that didn't work. I do not have multiple
sheets selected, which would not allow that property.
Does anybody have an answer?

Thanks!

 

[Don Guillett]

You should always post your code for comments, but this should work.

With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
'.otherthings
End With

 

[David Ponzio]

Unfortunately, that did not work. I also used the following statement,
in and out of the With statement:

ActiveSheet.PageSetup.PrintTitleRows = ActiveSheet.Rows(1).Address

Let me know if you have an answer-

Thanks-

David