View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Setting up a variable print range

Hi Gary

Did you not see your other thread
You get a couple possible solutions there

(Posted private also)

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Gary" wrote in 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