Try using:

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

Bill
---------------------
"Benoit" wrote in message
...
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