Excellent ... a really big thank you it was exactly what I wanted.

Bob


"zantor" wrote in message
...
Hi Robert,

I have attached a file called Robert.xls. I have written a procedure
called CopyMyCells1 (You will find it in Module1).

Have a look and see if it is wat you want.

File Attached: http://www.exceltip.com/forum/attach...?postid=262886
(robert.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/