Tag Archives: Charles Williams

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

Announcing Excel Summit South 2016!

Posted on November 28, 2015 by

After 2 years of organising, Charles Williams recently announced: EXTEND YOUR SKILLS This is a unique opportunity to: Learn from six of the world’s leading Excel MVP’s as they discuss the Excel topics most useful to you. Hear industry leading … Continue reading →

Posted in Excel | Tagged , , , , , | 1 Comment