newtonexcelbach.com
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 Exce…