Run-time error, why?
 

I have this line in my macro:
k = Log(Atn(x) * Sin(5 * x)) / Log(Cells(3, "L"))
But it gives me an error.

I can't figure out, why. Any ideas?
--
You can't know everything about everything.

Run-time error, why?
 

I know next to nothing about scientific functions but the vba help index for
LOG showsmy guess isk = Log(Atn(x) * Sin(5 * x)) / Log(Cells(3, "L"))k =
(Log(Atn(x)) * Sin(5 * x)) / Log(Cells(3, "L"))Static Function Log10(X)
Log10 = Log(X) / Log(10#)
End Function



--
Don Guillett
SalesAid Software

"Merike" wrote in message
...
I have this line in my macro:
k = Log(Atn(x) * Sin(5 * x)) / Log(Cells(3, "L"))
But it gives me an error.

I can't figure out, why. Any ideas?
--
You can't know everything about everything.

Run-time error, why?
 

Might you be taking the log of a number that is negative or is equal to
zero?

Test the individual components of the expression to determine
intermediate results.

Art


Merike wrote:
I have this line in my macro:
k = Log(Atn(x) * Sin(5 * x)) / Log(Cells(3, "L"))
But it gives me an error.

I can't figure out, why. Any ideas?
--
You can't know everything about everything.