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.

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

Open the Excel 2010 worksheet that contains the rows you want to delete. Press "Alt+F11" to launch the VBA code editor.

To show the sheet again, head back to the VBA window by pressing Alt+F11, select the relevant worksheet in the Project Explorer pane, change the Visible status to "xlSheetVisible," and save and ...