1. I still get the error message "Subscript out of range"
See if you have a space after you sheet name

2. How can I set the program to select the range automatically
What do you want to do?




--
Regards Ron de Bruin
http://www.rondebruin.nl


"jijy" wrote in message
...

Thanks Ron for the quick response. I copied the macro and replaced the
sheet names with my source and dest. sheet names.

I have two issues:

1. I still get the error message "Subscript out of range"

2. How can I set the program to select the range automatically (
instead of Range("A1:C10")) and where do I add that code.

Thanks a lot

Jijy


--
jijy
------------------------------------------------------------------------
jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042
View this thread: http://www.excelforum.com/showthread...hreadid=526332