another idea maybe?

LOGNORMDIST is rather complex, with 2 parameters.

I am able to use "Evaluate" with VBA
For example, my code contains already some instructions like this:


Dim iLastRow As Long
 Dim i As Long
 For i = 2 To iLastRow
        sFormula = "SQRT((N" & i & "))"
        Cells(i, "O").Value = Evaluate(sFormula)
Next i



But with LOGNORMDIST, it's different because 2 parameters
have to be used (mean and standard_dev)
These parameters can be calculated separately in two news columns
But how could I integrate theses values into sFormula?

Regards,

Fran?ois