Tag Archives: Array Range

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

Working With Range.FormulaArray In VBA

1 Introduction The Range.FormulaArray property is used to set or return the array formula of a range and works in a very similar way to the more familiar Range.Formula property. However, because of the fact that it is working in … Continue reading

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