Thanks to all. In my particular scenario, the cell will/should always
contain an alphameric entry (text if you will).

--
Donald
"Harlan Grove" wrote in message
...
"Tom Ogilvy" wrote...
I assume the OP can determine what is appropriate to his or her
situation.

They always have to anyway.

ActiveCell.Text appeared most appropriate to me in this instance. Dates
weren't an issue in the question and it wasn't offered as a turnkey
solution
to all such tests. As long as we are going to imagine any conceivable
situation, if in regional settings the user set MM dd, yyyy as the short
date format, then using value would be problematic as well:
..
So value2 would need to be used in that case.

In the sense that the OP's single example, "cell contains <M T91490" made
it
appear the cells would contain text, then there would have been little
difference between .Text and .Value. I fully agree that .Value2 would have
made
more sense than your original suggestion of .Text.

--
To top-post is human, to bottom-post and snip is sublime.