How to Set PrintHeadings

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.