Tag Archives: Wndows Insider

Working with dynamic arrays in Excel

Posted on May 23, 2019 by

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 , , , , , | Leave a comment