Chi Square Function conversion to VBA

Hi Guys

I am unable to convert this function formula to VBA ... please advise ...

Formula:

=2*MIN(_xlfn.CHISQ.DIST(H33,H28-1,1),1-_xlfn.CHISQ.DIST(H33,H28-1,1))

Below code ... have substituted the Cells with Variables...

Pval = 2 * Application.WorksheetFunction.Min(WorksheetFunction.Chisq_Dist(Xstat,Size-1,1),1 - WorksheetFunction.Chisq_Dist(Xstat,Size-1,1))

Two issues:

1. The fact that you are seeing _xlfn. at the start of the function name, means it doesn't exist in your version of Excel. (it was added in 2010 I think)
2. You misspelled it in the code as Chisqu_Dist

The first one is obviously the more serious issue.

True ... Gives runtime error 1004 Unable to get Chisq_Dist property of WorksheetFunction class
Edit...Newbie Error did not even look at error msg

Just realized that the code is good ... Error is in values ....Xstat was incorrect

Hi rorya

Thanks for reply...Yes does not exist in 2007...Am using 2013 to develop Add in though...
Have now opened file in 2013 and the -xlfn, not present ...

You misspelled it in the code as Chisqu_Dist

Noticed that tx ...

Not the issue though...

Well, you haven't really given any information as to the problem!

Also, just to be clear, developing the add-in in 2013 will not make it work in 2007.