View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.