DaniWeb IT Discussion Community - Page setup + Print titles

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Visual Basic 4 / 5 / 6 (http://www.daniweb.com/forums/forum4.html)

- - Page setup + Print titles (http://www.daniweb.com/forums/thread168276.html)

dinilkarun

Jan 14th, 2009 5:38 am

Page setup + Print titles

1 Attachment(s)

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

dinilkarun

Jan 14th, 2009 7:57 am

Re: Page setup + Print titles

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

Comatose

Jan 14th, 2009 9:09 am

Re: Page setup + Print titles

Nice Find.

All times are GMT -4. The time now is 7:30 am.