Recent Comments
dougaj4 on Using Section Properties-… 
Mattias on Using Section Properties-… dougaj4 on Using Section Properties-… Mattias on Using Section Properties-… dougaj4 on ULS Design Functions – u… 
hadwao on ULS Design Functions – u… ULS Design Functions… on Concrete ULS spreadsheet … Working with dynamic… on Returning Arrays From VBA and… dougaj4 on Drawing in Excel – … 
J.D. on Drawing in Excel – … dougaj4 on The Largest Early World Map… 
Doug Glancy on The Largest Early World Map… 
Larry Schuster on How Reinforced Earth work… dougaj4 on ConBeamU 4.13 
roshan_rai@hotmail.c… on ConBeamU 4.13
Tag Archives: dynamic arrays
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
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
