Yes. Couple of tips: use datatypes on your parameter declarations and your Function declaration, and "Range" is a (very commonly used) object in Excel so picking a different name for your function ...
Is it possible to access Excel's various mathematical functions (specifically NORMSINV) from within VBA. I can sort of do what I want just by setting the value of a cell to a string like ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback