Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorksheetFunction.sumproduct limits?
Greetings and TIA for your time
With columns AA and AB blank, the WorksheetFunction.sumproduct in the code below returns zero as expected. Increasing the size of Array1 & Array2 by 1 element to 5462 or beyond results in a "Type Missmatch" error message. Please advise Sub TestSumProduct() Dim Array1 As Variant Dim Array2 As Variant Array1 = Range("AA1:AA5461").Value Array2 = Range("AB1:AB5461").Value MsgBox WorksheetFunction.SumProduct(Array1, Array2) End Sub -- David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorksheetFunction.sumproduct limits?
Hi,
It might be coincidence, but: 5462 * 12 = the max amount of rows in an Excel sheet (65532). It might very well be that the sumproduct function may only contain 5462 * 12 chunks of data But this is pure speculation ManualMan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WorksheetFunction with VBA | Excel Discussion (Misc queries) | |||
WorksheetFunction.Sumproduct(syntax... | Excel Programming | |||
worksheetfunction | Excel Programming | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming | |||
WorksheetFunction | Excel Programming |