OK, have tested this, but with your 3 cells range the ADO method is about 10
times slower.
Another drawback of the ADO method is that you will have to set a reference
to the
Microsoft ActiveX Data Objects x.x Library.

RBS


"Alf" wrote in message
...

Thank you sooo much RB!

Macro worked perfectly. Now I'm going to study it to see how it works.


--
Alf
------------------------------------------------------------------------
Alf's Profile:
http://www.excelforum.com/member.php...fo&userid=7112
View this thread: http://www.excelforum.com/showthread...hreadid=550766