VBA not seeing Excel functions 2

[craigber]

I'm writing some VBA code in Excel 2003. For some reason, the code does not recognize Excel functions such as SQRT and FDIST. When I try to compile the code, I get the error "Sub or Function not defined". Any ideas on what's happening?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[SkipVought]

Hi,

use Application.Sqrt(....)

Skip,

_[red][/red]

 

[Rofeu]

Hello,

as far as I know the worksheetfunctions sqrt and fdist are not supported in VBA.

There is however the function sqr in VBA which returns the square root.

You'll need to calculate the F distribution through it's mathematical equation.

http://mathworld.wolfram.com/F-Distribution.html

Cheers,

Roel

 

[craigber]

Rofeu,

Thanks. It worked great!

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[SkipVought]

Roel,

I did not know that, as a business application rather than a math/scientific type.

Thanx! ==> *

Skip,

_[red][/red]

 

[Rofeu]

Thanks for the star, glad to have been of help.