Page setup + Print titles

Thread Solved

Join Date: Feb 2008
Posts: 198
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Page setup + Print titles

 
0
  #1
Jan 14th, 2009
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
sample.JPG  
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 198
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Re: Page setup + Print titles

 
1
  #2
Jan 14th, 2009
ExcelSheet.PageSetup.PrintTitleRows = "Sheet1!$13"
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 2,413
Reputation: Comatose is a jewel in the rough Comatose is a jewel in the rough Comatose is a jewel in the rough Comatose is a jewel in the rough 
Solved Threads: 211
Team Colleague
Comatose's Avatar
Comatose Comatose is offline Offline
Taboo Programmer

Re: Page setup + Print titles

 
0
  #3
Jan 14th, 2009
Nice Find.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC