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, I want the contents of the failed cell to be selected (so the user can begin typing new content for the cell without touching the mouse). All I know how to do is:

MyCell.Select

which selects the cell, but not its contents.

-dlh