943,737 Members | Top Members by Rank

Ad:
Jan 14th, 2009
0

Page setup + Print titles

Expand Post »
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
Attached Thumbnails
Click image for larger version

Name:	sample.JPG
Views:	25
Size:	125.6 KB
ID:	8838  
Similar Threads
Reputation Points: 18
Solved Threads: 0
Posting Whiz in Training
dinilkarun is offline Offline
206 posts
since Feb 2008
Jan 14th, 2009
1

Re: Page setup + Print titles

ExcelSheet.PageSetup.PrintTitleRows = "Sheet1!$13"
Reputation Points: 18
Solved Threads: 0
Posting Whiz in Training
dinilkarun is offline Offline
206 posts
since Feb 2008
Jan 14th, 2009
0

Re: Page setup + Print titles

Nice Find.
Team Colleague
Reputation Points: 361
Solved Threads: 214
Taboo Programmer
Comatose is offline Offline
2,413 posts
since Dec 2004

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Help required
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Substraction code in MSFlex Grid





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC