Worksheet function returns "Invalid or Unqualified Reference"

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Worksheet function returns "Invalid or Unqualified Reference"

FAQ

Thread Tools

Display Modes

10-27-2017, 07:41 AM

SerenityNetworks SerenityNetworks is offline

Windows 10 Worksheet function returns "Invalid or Unqualified Reference"

Office 2016

Advanced Beginner

Join Date: May 2005

Location: Allen, Texas, USA

Posts: 37

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

Tags

binomdist, macro, udf

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:01 AM.