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:

Me	Kansas	Josh	5 - 6 PM	Hawaii	0.99
Me	Kansas	Josh	5 - 6 PM	Texas	0.2
Me	New Jersey	Sam	5 - 6 PM	Hawaii	0.99

[tr]
[td]RVP[/td]
[td]DMB[/td]
[td]Banker[/td]
[td]Block Friendly Name[/td]
[td]Banking Region[/td]
[td]BadPct[/td]
[/tr]

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.