How to print out the sheets with data only

  • Thread starter Thread starter Man Utd
  • Start date Start date
M

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 ?
 
You can select the range set the print area
under file>print area>set print area

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon
 
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
 
Hi Paul,

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