How to use VBA to delete rows with specific content in Excel

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.

Image: Imam Fathoni, Getty Images/iStockPhoto

The article How to use VBA to insert multiple columns in an Excel sheet reviews a VBA procedure that inserts multiple columns (and rows). It’s super easy and this VBA procedure in this article is similar, but more complex. In this article, we’ll review a VBA procedure that deletes rows in a selected range where a value in that range matches an input value supplied by you. The number of lines in the procedure looks a tad overwhelming, but it contains several comment lines for documentation purposes.

SEE: 83 Excel tips every user should master (TechRepublic)

I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use…

Keep reading the full content on the TechRepublic site.


Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Comment