Tag Archives: RADExcelFormulaExtensions

Self Extending UDFs – Part 2

In Self Extending UDFs – Part 1 I introduced a couple of VBA UDFs, rxlRESIZE() and rxlEXTEND(), which will correctly display an array of values without the need for the user to manually resize the formula. They achieve this by either automatically … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , | 7 Comments

Self Extending UDFs – Part 1

If you’re an advanced Excel user then I’m sure that at some point you’ve become frustrated with the clumsiness of array formulas. I’m talking about the situations where you have to fiddle around with your worksheet in an attempt to resize an array formula so the number of cells … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , | 15 Comments