Hi Tony

What version of Excel are you using? I have just tested ths again
using Excel 2000 and 2003 and it works fine.

If you are using XL 97 this could be why it doesn't work, though I
wasn't aware that this command wouldn't work and cannot test on 97
because I no longer have access to it.

BTW, a is a variable that holds the contents of cell A1, and UsrCell
the variable that holds the address of the currently active cell.

Interested to know.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=391261