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

--
bm446
-----------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...fo&userid=3394
View this thread: http://www.excelforum.com/showthread.php?threadid=54254