VBA to delete rows from multiple criteria using text from cells

[jrod59]

I am creating a registration process for programs and trips. I am creating a macro to delete all rows based upon 2 criteria "Resident Name" and "Program Name. This would be used should someone choose to cancel their registration.

This is what I have so far. I am stuck on the text string part of the formula. The text string will change anytime someone wants to cancel. Therefore, I can not hardcode the values.

My table is in Range A1:D1000. The text value of "Resident Name" is in cell H1 and "Program Name is in G1. I would need the macro to delete all rows from A1:D1000 if it matches the criteria in cells H1 and G1.

I know something special has to be done because H1 and G1 is text rather than a value.

Any help would be appreciated.

Please Login or Register  to view this content.

[Fluff13]

Cells is rows, columns so you are looking in row 8 & 9 for column A, so you need to swap them round.

[jrod59]

Thank you. And here I thought this was some impossible task.

[Fluff13]

You're welcome & thanks for the feedback.