PrintTitleRows
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!
|