Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- DigitGraph Spreadsheet and WebPlot Digitiser
- About Newton Excel Bach
- Linking Excel to C - 2
- Continuous Beam spreadsheet with moving load
- Numerical Integration With Tanh-Sinh Quadrature v 5.0
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Tag Archives: resizing array functions
Returning Arrays From VBA and Python
Most of the user defined functions (UDFs) presented on this blog return a multi-cell array, that must be entered by selecting the output range then pressing Ctrl-shift-enter to display all the results. This process has several inconveniencies: You need to know … Continue reading
Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged dynamic arrays, Excel, Python, resizing array functions, UDFs, using array functions, VBA, xlwings
1 Comment