Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max of VBA Array
I have a two dimensional array. I have tried to sum the second column of
it. When I test I get a sum of 0 but when I test the individual values I clearly get numbers that are greater than 0 and should then Max to the highest of those numbers. What I am I doing wrong? Public UnitOfferArray() As Variant Dim ArrayMax As Variant ArrayMax = Application.Max(Application.Index(UnitOfferArray, 0, 9)) ?ArrayMax 0 ?UnitOfferArray(1, 9) 49.2126 ?UnitOfferArray(2, 9) 39.7223 ?UnitOfferArray(3, 9) 28.0002 ?UnitOfferArray(4, 9) 27.943 ?UnitOfferArray(5, 9) 11.2936 ?UnitOfferArray(6, 9) 7.6502 ?UnitOfferArray(7, 9) 4.6001 ?UnitOfferArray(8, 9) 1.7726 ?UnitOfferArray(9, 9) 1.2268 ?UnitOfferArray(10, 9) 1.1163 ?UnitOfferArray(11, 9) 0 ?UnitOfferArray(12, 9) 0 ?UnitOfferArray(13, 9) 0 --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |