PDA

View Full Version : How do I delete something based on headers?



doctortt
02-13-2014, 08:05 AM
Here is the scenario.C8 = "#", D8 = "MW", E8 = "$", and B11 = "Closed".I'm not sure how to write the codes to delete C11, D11, and E11. The issue here is that "Closed" could get relocated to any cell in column B. I'm looking to see if I could have something to perform the delete function using the header names, not the cell(row, column) reference.

westconn1
02-13-2014, 01:13 PM
i think more details are required
you want to delete any row with closed in column B?
row 8 remains constant?