Hello:

When I use this line in piece of code

targetRange(x) = Log(sourceRange(i) * 10)

The target range contains the natural log or ln value

When I use this line in a piece of code

Range("C1:C3").Formula = "=LOG(A1*10)"

The range log to base 10 or log value.

Why is that?

How do I get log to base 10 using the first line ?

Thanks

Ravi