Worksheet function returns "Invalid or Unqualified Reference"

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 04:32 AM.