Hello. I'm using Excel XP. I don't know what's causing the error message
for following code:

If Application.IsText(ActiveCell.Value) Then
sText = ActiveCell.Value
Else
sNonText = ActiveCell.Value
EndIf

I get an "Object Required" error message. Any thoughts?? I've tried the
following as well:

If Application.IsText(ActiveCell.Value) = True then
....etc

I don't get it. This code is all over the web as an example of how to use
"IsText" in VBA. Do I need a special DIM statement, or reference??

Thanks.

--
Craig