Recent Comments
Paul Halsema on The answer to Life the Univers… More powers of 3 | N… on The answer to Life the Univers… 
Onyia Leonard on Daily Download 4: Continuous B… The age of snakeoil… on They all laughed at Christophe… 
dougaj4 on Buckling of columns with varyi… 
Manoj Deo on Buckling of columns with varyi… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… Indexing pdf files,… on Indexing pdf content dougaj4 on The answer to Life the Univers… 
Matija Bandić on The answer to Life the Univers… 
Afazio on Plotting Mandelbrot dougaj4 on Plotting Mandelbrot Afazio on Plotting Mandelbrot r/excel - LINEST… on Weighted Least Squares Regress…
Tag Archives: Excel 2016
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 Excel, Excel 2013, Excel 2016, Problems with Transpose, Transpose, UDF, VBA, Worksheetfunction
6 Comments
