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!