Tag Archives: Excel 2013

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

Posted on 01/01/2016 by dougaj4

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

	py_ConBeamU and Stra… on py_ConBeamU
	py_ConBeamU and Stra… on ConBeamU and Strand7 check…
	ConBeamU and Strand7… on Using ConbeamU
	ConBeamU and Strand7… on ConBeamU 4.08…
	dougaj4 on The TrimRange Function
	khoitsma on The TrimRange Function
	py_UMom 1-05 \| Newto… on py_UMom 1.04
	py_UMom 1.04 \| Newto… on py_UMom spreadsheet and OptShe…
	Mandelbrot, Mojo, Nu… on Computing and plotting the Man…
	py_Numpy update 2: P… on Numpy where and split, and py_…
	Numpy where and spli… on Scipy functions with Excel and…
	py_RC Elastic 1.05 w… on Elastic Biaxial Bending
	py_RC Elastic 1.05 w… on py_RC Elastic 1.04 and fatigue…
	ConBeamU update \| Ne… on Using ConbeamU
	dougaj4 on Using ConbeamU

Tag Archives: Excel 2013

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

Categories

RSS Feed

Search NewtonExcelBach

Archives

Top Posts

Recent Comments

Blogroll

Family Links