Hello!
How can i set the range of rows, which should be repeated on every page?
With Excel, i wrote this:
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$6"
.PrintTitleColumns = ""
End With
Thanks, Klaus.
Hello!
How can i set the range of rows, which should be repeated on every page?
With Excel, i wrote this:
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$6"
.PrintTitleColumns = ""
End With
Thanks, Klaus.
Hello @KlausR
Sorry for the late reply.
I’m a bit confused. Do you mean that you want to set certain rows to be printed on every worksheet with SetPrintHeadings method?
Please clarify if I misunderstood.
Yes. How can i set the number rows? SetPrintHeadings could only be set to true.
I’m checking the situation. I will update this thread once I get the results.