If(ISERROR

[avitas]

Hi - I can't seem to get the ISERROR to work in VBA.
Numerator = X
Denominator = Y
Fraction = X/Y

X and Y varies in my macro (loops through loads of data). Sometimes Y will be zero and my macro fails.

I want to apply the IF(ISERROR function: Fraction = IF(ISERROR((X/Y),0,(X/Y)). But I only get run-time error or Division by zero error message.

Does this only work if you actually have a "physical" cell in a sheet that calculates X/Y returning #DIV/0! evaluated to TRUE using ISERROR? Or should it be possible using "virtual" variables in VBA too? (X and Y reads from a sheet but X/Y is not in my sheet, only a line of code in my modul. Thanks.

 

[Richard Schollar]

Without seeing your actual code it is very difficult to help. Please post the actual code you are using.

 

[avitas]

Sub test()

Dim ReturnVal, MyCheck
Dim x, y
x = 10
y = 0

ReturnVal = x / y
MyCheck = IsError(ReturnVal)

End Sub

 

[Richard Schollar]

Why don't you just check if the divisor (in this case y) is zero before you do the division?

 

[avitas]

I guess I could but there's already 2 IF's in my code screening numerators and denominators according to certain criteria leading to the division and I just find it harder to follow my own code. There's always workarounds byt it annoys me I know there's functionality that I can't get to work. But I guess as long as the division (ReturnVal) is only a variable in my code and not a calculation in a cell the IsError doesn't seem to work.

 

[Richard Schollar]

I believe IsError identifies if the CVerr function has been used to assign an error value to a variable. As far as I know it doesn't identify that an expression (such as 1/0) will return an error.