Recent Comments
dougaj4 on 3D plots with the latest … 3D plots with the la… on 3D Matplotlib Plots in Ex… Suelio Josileissu on 3D plots with the latest … Installing Python an… on SectionProperties update 3 Dan & naD | Newt… on The Daily Mail Song dougaj4 on ULS Design Functions 2.13 
Alvin on ULS Design Functions 2.13 
Larry Schuster on Microsoft blocking VBA in down… dougaj4 on Downloads 
Sunny on Downloads dougaj4 on Section Properties with MeshPY… 
Alex on Section Properties with MeshPY… Alex on Section Properties with MeshPY… Installing PyPardiso… on Installing PyPardiso and speed… Installing PyPardiso… on Making Finite Element Analysis…
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 