Deleting rows conditionally

[Todd Huttenstine]

Hey guys

What is the code to delete the entire row if the value in
the cell in column T equals "BSC"?

The code needs to look in every cell in column T and if it
finds the value "BSC", then that entire row must be
deleted.

Thank you

Todd Huttenstine

 

[JE McGimpsey]

Todd -

You post often enough to know that this is an FAQ. Search the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*

You'll find hundreds of threads on conditional deletions (including some
of your own).