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.

Regards,
Dinil

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

Nice Find.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.