Tag Archives: delete rows

Delete Rows If All Cells In A Given Range Are Empty

Deleting rows. We all need to do it from time to time and I often find myself referring to how to delete rows using VBA. It has a bunch of handy code snippets and notes on using Range.Find(), Range.Autofilter() and Range.SpecialCells() … Continue reading

Posted in Microsoft Excel | Tagged , , , | 1 Comment

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