>That worked for printing landscape. Do you know how to print rows 1 and 2 on every page.
>
>I am trying to modify the following:
>
>ObjExcel.ActiveSheet.Pagesetup.PrintTitleRows($1:$2)
>
>Thanks in advance for the help.
I don't really understand what you are trying to achieve, but in any case you can record macro in Excel and compare with your code.
HTH
Oleg