Monthly Archives: May 2012

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 , , , , , , , , , , , , , , | 13 Comments

VLOOKUP Week Mug!

Towards the end of March I published three posts on here which were especially written for VLOOKUP week. If you missed VLOOKUP week then it’d be well worth your time to check out some of the fabulous articles written by Excel experts from … Continue reading

Posted in Off Topic | Tagged | Leave a comment

Get The Last Used Row In VBA Using Range.End

In the last post we saw a really flexible function which can pull out the last used row from a range of any dimensions. Sometimes I use a different approach though: if I know I want to look at only … Continue reading

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