IsError function doesn't accept value

Hi,

I have the following variable:

Please Login or Register  to view this content.

Sometimes setScale has the value 07 (then I want to loose the 0), sometime it has a value like 9B (in that case setScale can remain the same). I would expect that in the latter case setScale + 0 would return an error, but I get a type mismatch error, which is exactly why I build the IsError around it. When I apply the function in the worksheet itself, it does work..

Any thoughts?

Bart

Hi,

IIf always evaluates both the True and False parts. You should use an If..Then clause instead. Also, trying to add a 0 to a non-numeric string will cause a runtime error, not return an error value. You should use an error handler or test with IsNumeric or Like. Certain strings that you might not expect can be converted to numbers- e.g. 9E1 or 8D2- so Like is probably a better choice.