How to print out the sheets with data only

[Man Utd]

I have a worksheet which has row 1 to row 100 data inside, how do I write
code/macro to print only up to the row 100 but not the many pages with blank
data ?

 

[Peo Sjoblom]

You can select the range set the print area
under file>print area>set print area

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

 

[Paul B]

Man Utd, you may also want to reset the used range, see this for how to do
it

: http://www.contextures.com/xlfaqApp.html#Unused

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Man Utd]

Hi Paul,

I found the subroutine, however, where should I put this subroutine into? In
which event handler ?