Tag Archives: Fast Excel

Working with dynamic arrays in Excel

Posted on 23/05/2019 by dougaj4

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

High Speed Blog …

Posted on 07/06/2011 by dougaj4

… brought to you via Smurf on Spreadsheets If you want your spreadsheets to go faster, Charles Williams is the man to tell you how to do it.  Charles has recently started a blog on the subject: FastExcel Well worth … Continue reading →

Posted in Excel, VBA | Tagged , , | Leave a comment