IsText VBA Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig - 24 Jan 2006 08:31 GMT

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.

Signature

Craig

Reply to this Message

NickHK - 24 Jan 2006 09:05 GMT

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

> Hello. I'm using Excel XP. I don't know what's causing the error message
> for following code:
[quoted text clipped - 15 lines]
>
> Thanks.

Reply to this Message

Craig - 24 Jan 2006 19:45 GMT

Yes...and I don't understand why it's happening. I even tried your
"Worksheetfunction" example, and it doesn't work.

Signature

Craig

> Craig,
> I would have said that you are missing the "WorksheetFunction" between
[quoted text clipped - 23 lines]
> >
> > Thanks.

Reply to this Message