Monthly Archives: April 2012

Get The Last Used Row In VBA Using Range.Find

Here’s one of my favourite, custom functions, GetLastUsedRow. It’s really flexible because it can be used on any type of range and, in particular, across multiple columns. Here are some examples: The key points you need to be aware of are: If … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , | 2 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

SUMIF Formulas

1 Introduction At some point in your Excel work you are almost certainly going to want to conditionally sum a range of cells. If you find yourself in that situation then SUMIF() is probably going to be what you need: … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , , , , , , , , , , , , , | 12 Comments