You can use the range example with

Set sourceRange = mybook.Worksheets(1).Range("A20:IV25")


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


"bm4466" wrote in message
...

Thanks a lot, that is exactly what i needed. Just one question - if i
only want to choose certain rows to be copied - say rows 20-25, how do
i go about doing that? Sorry...I'm pretty new to this.
Thanks, Ben


--
bm4466
------------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...o&userid=33949
View this thread: http://www.excelforum.com/showthread...hreadid=542548