Deleteing rows or columns is a common requirement in VBA. There are a number of ways to achieve this, 3 of which are discussed here.

The three techniques presented are:-

• - the obvious way, but the proper way
• - saving matching cells within a loop, and delete en-bloc at the end
• - the fast way, using Excel's built-in AutoFilter facility