Worksheet function returns "Invalid or Unqualified Reference"

[SerenityNetworks]

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

Sub TestIt()
    Dim cdf As Double
    cdf = .BinomDist(3, 551, 0.01, True)
    Debug.Print cdf
End Sub

[NoSparks]

maybe

cdf = application.worksheetfunction.binomdist(3, 551, 0.01, True)

[SerenityNetworks]

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.