Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- ULS Design Functions 2.13
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Fitting high order polynomials
- Downloads
Recent Comments
Tag Archives: Problems with Transpose
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