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!

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

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

"David Ponzio" wrote in message
...
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!

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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!