Standard deviation and other formulae

[Guest]

Hi,

A very simple question for a regular user. I simply want to use 'normal'
excel formulae within vba. In this case, I wanted to calculate the standard
deviation of a range called 'LSRatio'.
But when I do this, I get an error message saying function not defined.
What shall I do for this one in particular, and for others like average etc
etc?
Thanks a lot

 

[Bill Martin]

Try using:

X = Application.WorksheetFunction.STDEV(....)

Bill