Setting print range using VBA
 

Isn't the default print area the same as the used range?
If you clear the print area initially, Excel will do the
rest.

Cheers,
Dave.

-----Original Message-----
I am looking for an easy way to use a macro to select a
print range by determining the last row and column used.
However, the last row and column used will change between
users. For example, if the user only used up to row 98
and
column L is the last column used. I need to select the
range A1 to L98 and print this range. Thanks for any
input.

gary
.