| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to a certain column in an array
Hello,
I have an array with 10 column and many rows I want to perform an Excel function (as average) on a specific column Is there a way to do it directly? I look for something as : Application.Average(MyArray(*,6)) for the average of column 6 Thanks for your help Avi |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referring to a certain column in an array
One way:
With Application.WorksheetFunction Debug.Print .Average(.Index(MyArray,,6)) End With In article , avi wrote: Hello, I have an array with 10 column and many rows I want to perform an Excel function (as average) on a specific column Is there a way to do it directly? I look for something as : Application.Average(MyArray(*,6)) for the average of column 6 Thanks for your help Avi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to a row or column | Excel Programming | |||
| Referring to a column | Excel Discussion (Misc queries) | |||
| Referring to multiple elements of an array (VB) | Excel Programming | |||
| Referring to a column | Excel Programming | |||
| Referring to Microsoft Excel array in VBA | Excel Programming | |||
Linear Mode
