Tag Archives: Range.FormulaArray

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

SUMIF From VBA

There are three ways we can be involved with SUMIF() when we are using VBA. The Range.Formula(), Range.FormulaR1C1() and Range.FormulaArray() Properties This is a straightforward process. To enter a formula containing SUMIF() we use the Range.Formula or Range.FormulaR1C1 properties: If … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , | Leave a comment