Tag Archives: specialcells

VBA: Determine All Precedent Cells – A Nice Example Of Recursion

I’ve been working on a project for this blog which I’ve found quite demanding. It’s taken me to parts of the Excel object model which I’ve never explored and challenged me to do some pretty difficult things. One aspect of … Continue reading

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

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