Easy (for you) question
Thank you sir,
Worked Great.
"Dave Peterson" wrote:
This (still) worked ok for me:
Option Explicit
Sub testme01()
Dim myArr As Variant
myArr = Array(1, 2, 3, 4, 5)
MsgBox Application.StDev(myArr)
End Sub
I could use this, too:
MsgBox Application.WorksheetFunction.StDev(myArr)
Albert wrote:
Hello!
I'm trying to get the standard deviation of the values in a one dimentional
array.
Excel obviously has the function, but the necesary argument is a range.
I was thinking of calculating the st.dev manually, but that not very cool.
Is there a way of using the items in an array as the arguments for the
Standard Deviation Worksheet.Function?
Thanks in advance,
Albert C
--
Dave Peterson
|