Highlight matching rows (2 step macro)

[85characters]

Hi,

I have been trying unsuccessfully to create two macros in one dynamic worksheet (it changes all the time) using VBA. Ideally, macro 1 would highlight each row that has a match across columns A:D, and then macro 2 would then delete all matching rows.

So, the worksheet is entitled "Template" and it looks like this:

[table="width: 500"]
[tr]
[td]RVP[/td]
[td]DMB[/td]
[td]Banker[/td]
[td]Block Friendly Name[/td]
[td]Banking Region[/td]
[td]BadPct[/td]
[/tr]
[tr]
[td]Me[/td]
[td]Kansas[/td]
[td]Josh[/td]
[td]5 - 6 PM[/td]
[td]Hawaii[/td]
[td]0.99[/td]
[/tr]
[tr]
[td]Me[/td]
[td]Kansas[/td]
[td]Josh[/td]
[td]5 - 6 PM[/td]
[td]Texas[/td]
[td]0.2[/td]
[/tr]

[tr]
[td]Me[/td]
[td]New Jersey[/td]
[td]Sam[/td]
[td]5 - 6 PM[/td]
[td]Hawaii[/td]
[td]0.99[/td]
[/tr]
[/table]

I want macro 1 to highlight rows 1 and 2 since they match between columns A through D. Then I want macro 2 to delete matching rows, like 1 and 2, from the worksheet.

Is this possible? I could not find a forum that addressed these two specific questions.

Thank you in advance! Also, any help would be appreciated.
- 85characters

 

[85characters]

I figured it out! False alarm.