application.Log : different results and computing time

[xavnyc]

Hello,
in two adjacent columns i am running the following VBA codes:
column K
With Range("d3")
Range(.Cells(1, 1), .End(xlDown)).Offset(0, 7).FormulaR1C1 = "=ln(RC[-7])"
End With
column L
Dim k As Integer
For k = 3 To dataCount
Sheets("DataProcess").Cells(k, 12).Value = Application.Log(Cells(k, 4))
Next k

i am running those into 2 adjacent columns since they are both suppose to return same results (ie LN(whatever value is in column D).
They are not returning same values. With 23.85 in column D, column K returns 3.17 amd column L 1.37.
ANy idea why?

Also, both of those loops take a really long time to run (about 5sec), whereas my loops with application.STDEV are blazing fast.

I dont get it.

Any help much, much appreciated

thanks

 

[GlennUK]

Well, the most obvious answer is that you are using Application.Log instead of Application.Ln

By the way the VBA function Log is called without specifying Application as a qualifier, otherwise the spreadsheet function Log is called instead ( Log base 10 ).