Just note that these were added in xl2002 and would not be available in any
earlier version (if you are writing code to distribute).

--
Regards,
Tom Ogilvy

Dave Peterson wrote in message
...
Take a look at ErrorCheckingOptions in VBA's help.

From there, you can click on "see also" and go to "Error Object" and see
code
like this:


Option Explicit
Sub testme01()
Dim myCell As Range

Set myCell = ActiveSheet.Range("B3")

If myCell.Errors.Item(xlNumberAsText).Value = True Then
MsgBox "Might be an error"
Else
MsgBox "nope, not even a warning"
End If

End Sub


Trevor Fernandes wrote:

Not really.

What I was trying to access is the error indicators like "The number in
this cell if formatted as text...."

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

--

Dave Peterson