Recent Comments
Sean on Publications 
dougaj4 on Downloads 
Jose on Downloads SectionProperties up… on Section Properties with MeshPY… dougaj4 on Beam geometric non-linear… dougaj4 on Non linear regression –… 
Torben Jensen on Non linear regression –… 
robertocastanocrespo on Beam geometric non-linear… dougaj4 on Cubic Splines 
Amar Khalifeh on Cubic Splines dougaj4 on Finding square roots … 
Juggler_IN on Finding square roots … dougaj4 on Tanh-Sinh Quadrature v. 5… 
metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Tanh-Sinh Quadrature v. 5…
Tag Archives: Wndows Insider
Working with dynamic arrays in Excel
Many of the VBA functions available here return results as arrays, which must be entered by selecting the desired output range, then pressing Ctrl-Shift-Enter (CSE). This can be inconvenient (or at least untidy) when the size of the output array varies. … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Charles Williams, dynamic arrays, Excel, Fast Excel, VBA, Wndows Insider
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 