| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy question | Excel Discussion (Misc queries) | |||
| *EASY* question 2!! | New Users to Excel | |||
| Easy Question | Excel Programming | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Probably the most easy question here... | Excel Programming | |||
Threaded Mode
