I think you are going to have to provide more details about what it is you
want do.

--
Rick (MVP - Excel)


"johnsail" wrote in message
...
What do you test for if enter key only has been used to move on to another
cell?
testing for "" only seems to work if "delete" has been used in the cell.

regards