Testing for text
 

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

Testing for text
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

Art wrote:
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

Thanks Frank. (eom)
 

-----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

Art wrote:
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
.