You can select the range set the print area
under fileprint areaset print area

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Man Utd" wrote in message
...
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 ?