J
jksmurf
I'm stumped. I have a simple calculation in a Macro which results in a
-ve number.
Gr = ((1 - 2 / a) / (1 + x * sqr(2 / (a - 4)))) ^(1 / 3)
I did a watch on a and x, they are 191 and -21.
The error is " Run-time error '5' Invalid procedure call or argument "
Oddly, if I perform the SAME calc in the Worksheet it works FINE. I
just fails in VBA?
Any ..um ... hints?
k
-ve number.
Gr = ((1 - 2 / a) / (1 + x * sqr(2 / (a - 4)))) ^(1 / 3)
I did a watch on a and x, they are 191 and -21.
The error is " Run-time error '5' Invalid procedure call or argument "
Oddly, if I perform the SAME calc in the Worksheet it works FINE. I
just fails in VBA?
Any ..um ... hints?
k