This ought to be very easy, but browsing the help files doesn't help:

I'm writing my own data validation routine. If the validation fails,
want the contents of the failed cell to be selected (so the user ca
begin typing new content for the cell without touching the mouse). Al
I know how to do is:

MyCell.Select

which selects the cell, but not its contents.

-dl

--
dl
-----------------------------------------------------------------------
dlh's Profile: http://www.excelforum.com/member.php...fo&userid=2611
View this thread: http://www.excelforum.com/showthread.php?threadid=39994