PrintTitleRows

  • Thread starter Thread starter David Ponzio
  • Start date Start date
D

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!
 
You should always post your code for comments, but this should work.

With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
'.otherthings
End With
 
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
 
Back
Top