Is there a way round or a Patch for this limitation
Although Excel 2007 has far more rows than the Old 65536
it would appear that you cannot pass an array bigger than 65536 rows to a Worksheet Function
There may be Patch for this.
Anyone found a solution other than splitting the array or using worksheet cells
If you pass the worksheet functions a range then they can cope with the full number of sheet rows.
If an array, then you get the Mismatch error.
This is NOT a sheet in compatibility mode.
conLimit = 65536
conLimit > 65536