Macro to delete a row

[NoIdeaWhatsoever]

what coding would I use to delete an entire row if the cell in the column met a certain conditional requirement? For example: I want to delete every row for which each cell in column A = Bob. Thanks

[shg]

Welcome to the forum.

If you search the forum, for delete rows, you'll find dozens of examples, e.g., http://www.excelforum.com/excel-prog...ting-rows.html

[Leith Ross]

Hello NoIdeaWhatsoever,

Welcome to the Forum!

This macro will delete all the cells in column "A" starting at row 2. The macro looks for the word "Bob" (case is ignored) and then deletes all rows that contain it. You can change the starting point by changing the starting address of the search. You can also change what to look for. These are marked in red in the macro.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

[mudraker]

Please Login or Register  to view this content.