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
|