View Single Post
  #1   Report Post  
David Roodman
 
Posts: n/a
Default "Unable to get the NormSInv property of the WorksheetFunction clas

Hello.
I am writing a function in Excel 2002. In context, the following watch
expression works fine:
Application.WorksheetFunction.NormSInv((1)
But this one:
Application.WorksheetFunction.NormSInv(1)
generates the value:
<Unable to get the NormSInv property of the WorksheetFunction class

Both NormSInv and NormSInv are listed in my object browser window, and as
taking one argument. Does anyone have any idea what's going on here? I'll be
grateful for any help you can offer.
David Roodman
Center for Global Development
Washington, DC