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 |
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 |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com