Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to perform function (e.g. Sum, Average) on VB 3-d Array
Hi there
can I use a excel function such as SUM on a 3d array? e.g. Dim array1(10,10,10) Dim av1 as integer av1 = Application.WorksheetFunction.average(array1(1,1,1 ):array1(10,1,1) debug.print av1 many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding or to previously provided Average If Array function | Excel Worksheet Functions | |||
Adding if to Average If Array function | Excel Worksheet Functions | |||
how do I perform a conditional average with exclusions? | Excel Discussion (Misc queries) | |||
Small Array is too big for AVERAGE Function? | Excel Worksheet Functions | |||
perform 1 function, stop, perform different function | Excel Discussion (Misc queries) |