clear the print area..and you'll get the same result.

Caveat: ensure your "UsedRange" is not contaminated
by formatting outside of your data area. check that
by pressing ctrl-end.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


RD Wirr wrote :

Can anyone give me a routine for automatically printing a range based
on how many rows of a spread sheet are filled? I think I could set up
a dynamic range to determine all the rows filled with data but then I
need a VBA routine to actaully select that range and set it as the
print area and then print or go into print preview mode. Any help
would be much appreciated. Thanks,
RD Wirr