Natural log function

[Mitch]

I am trying to use the Ln (natural log) function in a cell formula produced
by VBA. The compiler tells me that the Ln function is not defined. Below is
my code. Any suggestions?
If EarlyTrendType = "Logarithmic" Then
Cell.Value = ActiveSheet.Range(L1).Value * Ln(Cell.Offset(0,
-2).Value) + _
ActiveSheet.Range(L2).Value
End If
Note that L1 & L2 are the cell address' for the regression coefficients
produced by Linest().

 

[merjet]

Use one of these:
Application.Worksheetfunction.Ln()
Application.Ln()
Log()

Merjet