Print area

[q4s72534]

How do you set up a print area for an excel spredsheet in vb . I want to print one page, only the area i want to see.


ex:


jd;jadljaklfdjlkaj
dj;fjafjakjfajkfjd
asld;fjasjdfkajfkja

don't want to see the 3rd line "asld;fjasjdfkajfkja"



Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[SkipVought]

Hi,

1 turn on the macro recorder
2 set the print area
3 turn off the macro recorder
4 view the VBA code and modify if necessary



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com