Craig,
I would have said that you are missing the "WorksheetFunction" between
"Application" and "IsText" (as IsText is part of Excel, not VBA), but
Application.IsText works.
You sure the error is occurring on that line ?

NickHK

"Craig" <Craig@discussions.microsoft.com> wrote in message
news:7F0B1A8A-1A18-4091-A344-1C661ACE083E@microsoft.com...
> 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