ExcelBanter - Evaluate formula using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Evaluate formula using VBA (https://www.excelbanter.com/excel-discussion-misc-queries/40712-evaluate-formula-using-vba.html)

Ali Baba

Evaluate formula using VBA

How can I write a VBA code to evaluate this formula

Y = alpha*EXP(-alpha*(X-U)-EXP(-alpha(X-U)))

All times are GMT +1. The time now is 08:18 PM.