Good Evening All,

I have this one line of script that is causing me all sorts of headaches. I'm simply trying to move a calculation of lognormal randoms horizontally, & i continually get the afformentioned error. Any assitance or advice would be greatly appreciated.


Thanks,


Script Causing Error:

Cells(X, 5).Offset(0, Count).Value = WorksheetFunction.LogInv(WorksheetFunction.NormSDist(Rnd()), Worksheets("Log Sim").Range("E8").Offset(0, Count).Value, Worksheets("Log Sim").Range("E9").Offset(0, Count).Value)