Stuart McLachlan
stuart at lexacorp.com.pg
Thu Oct 23 01:57:14 CDT 2008
Oops, try this: Simplest way is to set a reference to Excel and then use the NormSDist() function: Function NormSDist(ZScore As Double) As Double Dim xlapp As New Excel.Application NormSDist = xlapp.NormSDist(ZScore) xlapp.Quit Set xlapp = Nothing End Function -- Stuart