Thread: How to print out the sheets with data only

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" <alanpltseNOSPAM@yahoo.com.au> wrote in message
news:ewvqh4DMGHA.668@TK2MSFTNGP11.phx.gbl...
>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 ?
>
>

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" <alanpltseNOSPAM@yahoo.com.au> wrote in message
news:ewvqh4DMGHA.668@TK2MSFTNGP11.phx.gbl...
> 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 ?
>
>

Hi Paul,

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

"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
news:uiwfPkEMGHA.2276@TK2MSFTNGP15.phx.gbl...
> 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" <alanpltseNOSPAM@yahoo.com.au> wrote in message
> news:ewvqh4DMGHA.668@TK2MSFTNGP11.phx.gbl...
> > 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 ?
> >
> >
>
>