Please help me in automatinng the following in my EXCEL sheet using VB.
I want to make my first two rows as Repetitve in every page of print.In excel it can be done as

PAGE SET UP->SHEET -> Print titles -> "Rows to repeat at top".
here i can choose the first 2 rows.Please help me do that in VB.


ExcelSheet.PageSetup.PrintTitleRows = "Sheet1!$1:$3"

commented: Nice Find. It's nice to have people post the answer when they find it. If you have found the answer, you can mark the thread as solved :) +8