Unable to get the NormDist of the Worksheet Function
try
XlApp.NormDist
and see if that works.
--
Regards,
Tom Ogilvy
Stef C wrote in message
...
Hi,
I have a cost simulation application using the normdist
function of excel. It was working fine until today when I
get the Run-Time error 1004: Unable to get the NormDIst
Property of the WorksheetFunction class.
I am using this formula with a Excel Object
(XlApp.WorkSheetFunction.NormDist). I must have change
something to my code (I do not remember having change a
thing on this object but...)
Help would be greatly appreciate.
|