Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- Daily Download 5: Frame Analysis
- Contour plots with Excel and Matplotlib
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- Daily Download 4: Continuous Beam Analysis
- Cubic Splines
Recent Comments
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