Testing for text

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

How can I check the cell contents to identify whether the
value is text or not?

I thought I could get there with the IsNumeric function:
IsNumeric(ActiveCell) returns:

A blank cell is true.
A number is true.
Text is false.

So far so good, BUT ...

A date (like 3/15/2003) is FALSE! That doesn't work for me.

Art
 
Hi Art
you may try
If IsNumeric(Activecell.value) or IsDate(Activecell.value) then
msgbox "no text"
end if
 
-----Original Message-----
Hi Art
you may try
If IsNumeric(Activecell.value) or IsDate (Activecell.value) then
msgbox "no text"
end if

--
Regards
Frank Kabel
Frankfurt, Germany

.
Click to expand...
 
Back
Top