I'm a VBA rookie who's banging his head on his desk w/this one:

(I'm running Excel 2007 on Win XP)

I have a worksheet that has data similar to this in Column A:

Data Type A

A

B

C

Data Type B

A

B

C

Data Type A

A

B

C

...and so on...

Note that in my data set I'm working with the A,B,C data rows are separated from the next instance of Data Type by a blank row.

I'm trying to create a macro that will loop through and find each instance of the value "Data Type A" and delete that row, as well as the data rows A,B,C etc below it, but leave Data Type B and its respective data rows in the spreadsheet.

Any help would be greatly appreciated.

Thanks!