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" 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 ?