Tag Archives: Excel 2013

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

It is (fairly) well known that when using Worksheetfunction.Transpose on an array in VBA the array must be no more than 65,536 (2^16) rows long, or it will return an error. Recently when using Excel 2016 (32 bit) I thought … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , , | 6 Comments