Member Avatar for dinilkarun

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

sample.JPG 125.57 KB
  • 2 Contributors
  • 2 Replies
  • 132 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Comatose

Recommended Answers

All 2 Replies

Member Avatar for dinilkarun

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
Member Avatar for Comatose

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.