Tag Archives: Range.Find

Deleting Rows With VBA

A few years ago I posted a series of VBA samples on a forum which outlined different ways to delete rows in an efficient manner. The series proved to be very popular and, since that forum is now in decline, I’m going to resurrect those notes on here. The … Continue reading

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

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