brothertruffle880
asked on
Excel VBA Syntax - ISNUMERIC versus ISTEXT oddity?
Why do I need to prefix the test with "application." for "istext" but I don't need to add "application." for "isnumeric"?
If Application.IsText(ActiveC ell.Value) Then
MsgBox "yes"
End If
-------------------------- ---------- ---------- ---------- ----
If IsNumeric(ActiveCell.Value ) Then
MsgBox "yes"
End If
If Application.IsText(ActiveC
MsgBox "yes"
End If
--------------------------
If IsNumeric(ActiveCell.Value
MsgBox "yes"
End If
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.