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
|