#1
|
|||
|
|||
Worksheet function returns "Invalid or Unqualified Reference"
I'm trying to use the BINOMDIST function in a UDF. I'm at a loss as to why it won't calculate. If I enter the formula =BINOMDIST(3,551,0.01,TRUE) in a worksheet then it correctly returns 0.199. When I try to use the same in a UDF it doesn't work. What am I doing wrong?
Thanks, Andrew Code:
Sub TestIt() Dim cdf As Double cdf = .BinomDist(3, 551, 0.01, True) Debug.Print cdf End Sub |
#2
|
|||
|
|||
maybe
cdf = application.worksheetfunction.binomdist(3, 551, 0.01, True) |
#3
|
|||
|
|||
Thank you. That was it. I had tried cdf = .worksheetfunction.binomdist(3, 551, 0.01, True) , but that didn't do it. However, I just found leaving the dot off before worksheetfunction works okay. Much appreciated.
|
Tags |
binomdist, macro, udf |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bibiography citation gets "Invalid source specified" error | Jennifer Murphy | Word | 9 | 03-26-2017 11:21 PM |
PPT for Mac: The value "#" is invalid. Please Provide a valid value. | dshmed | PowerPoint | 0 | 11-23-2016 11:25 AM |
How to use a "Save As" button without causing digital signatures to become "Invalid"? | jferg | Word VBA | 0 | 02-16-2016 03:04 PM |
Making cross-reference say "Fig." instead of "Figure" | dgalb | Word | 17 | 11-09-2014 06:25 AM |