Tag Archives: last row

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

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