| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Standard deviation and other formulae
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Standard deviation and other formulae
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| standard deviation | Charts and Charting in Excel | |||
| standard deviation | Charts and Charting in Excel | |||
| Standard Deviation | Excel Worksheet Functions | |||
| Standard Deviation | Excel Worksheet Functions | |||
| standard deviation | Excel Discussion (Misc queries) | |||
Linear Mode
