Excel vba to delete rows based on multiple criteria
Posted on 2014-11-06
I have text in Column A that is separated by some blank rows throughout. I'd like to have code that will find certain text in Column A and delete those rows. With the example below, what code could run through Column A of the active sheet, despite blank rows, and delete all rows with the words "Client:", "Media:" or "Product"?
Please let me know if further clarification is required. Thank you!!!