I assumed Col A, Col B , Colc you have data.

If Col A - A2 contains word "Group ???? ?? " then delete below 2 rows.

if not jump to next row and find cell A3 has "Group ????? ?? " if yes
delete below 2 rows. ??

Is I am right ?


On Oct 31, 11:02*am, "tom" wrote:
Hi,

A * *B * *C
D * *E * *F
G * *H * *I

are a block of cells. Cell C is the active cell (cursor position). If cell D
contains the word "Group" e.g. "Group 3 and below", or "Group 4 and above",
I want to delete the contents of cells D, E, F, G, H and I. If not, to
continue on with the next line of code. Any help is much appreciated.

TIA
Tom