Print macro
 

I have set up many print macros within a sheet. My first Marco is set to
print cells A1:E20. If someone inserts a row between the range, how can the
print macro automatically update to A1:E21? If that row is inserted, then
all my other macro ranges are incorrect. Thanking you in advance.
--
Dan

Print macro
 

Maybe you can use this

Range("A1").CurrentRegion.PrintOut



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dmb4473" wrote in message ...
I have set up many print macros within a sheet. My first Marco is set to
print cells A1:E20. If someone inserts a row between the range, how can the
print macro automatically update to A1:E21? If that row is inserted, then
all my other macro ranges are incorrect. Thanking you in advance.
--
Dan