Help with macro that will delete a set series of rows from column "A".

[IrishMist1748]

Hello!

I need a macro that will delete a repeating series of rows? What I am faced with is a set series of rows (see the series below) in column "A" that is repeated on occasion. What I need to happen is for all the rows in that series to be deleted each time it is found WITHOUT even one set of the series remaining in column "A".

Thank you!

[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]Type[/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]Sizes[/TD]
[/TR]
[TR]
[TD]Gallery[/TD]
[/TR]
[TR]
[TD]Shape[/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]Grade[/TD]
[/TR]
[TR]
[TD]Count[/TD]
[/TR]
[TR]
[TD]Shape[/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]Grade[/TD]
[/TR]
[TR]
[TD]Type[/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]Shape[/TD]
[/TR]
[TR]
[TD]Grade[/TD]
[/TR]
[TR]
[TD]Count[/TD]
[/TR]
[TR]
[TD]Center[/TD]
[/TR]
[TR]
[TD]Accent[/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

IrishMist1748,

You are very welcome. Glad we could help.

Come back anytime.