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.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

In this article we will show you how to add a sheet to an Excel workbook using VBA. There are 2 different methods detailed below in order to do this.

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 ...