IsError?

[charlie79]

Can I use the excel IsError function in VBA code? I have a refresh timer running every five secs, and from time to time, some cells contain !NULL#. This is a result of a add-in bug. I am checking for the string "!NULL#" right now, but it doesn't seem to work. I'm using something like:
if cells(6, 1).value = "!NULL#" then
do something
else
do something else
end if
Any ideas?

 

[Legacy 98055]

No it will not
MyType = TypeName(Cells(6, 1).Value)
Notice typename.
Cells are variants by default.
A variant can contain most any datatype.
If Cells(6, 1).Value contained a string "Error" then in the above code:
MyType would = "String" not "Error".
TypeName is a VB function which returns the data type of the variant.
In this case an Error

Tom
This message was edited by TsTom on 2002-04-02 08:09

 

[charlie79]

Great! Thanks for the explanation Tom. I'm not the type of person who takes a solution and runs, I like to understand what I'm using. Thanks again!

 

[charlie79]

Tom, or anyone, after running that code from Tom I'm getting an Invalid Qualifier error. It points to the
myType = TypeName(Cells(8, 1).Value)
line (highlighting typename). Is this a problem with my variant myType, it is declared as a String. ???

 

[Legacy 98055]

Hey

The function TypeName returns a string.
I'm using Office 2000.
I do not know if this function came with earlier version of VB/VBA?

I tested the code as such:

Placed this formula in A1 to generated the #NULL! error.
=SUM(B1 C1)

Ran this code to see what would be assigned.

Sub SeeError()
Dim MyType As String
Dim CheckCell as Boolean

CheckCell = IsError(Cells(1, 1).Value)
MyType = TypeName(Cells(1, 1).Value)

Debug.Print "CheckCell = " & CheckCell
Debug.Print "MyType = " & MyType

'CheckCell = True
'MyType = "Error"
End Sub

It works for me!
Tom
This message was edited by TsTom on 2002-04-02 11:07