Firstly, Merry Christmas to everyone who has used mrexcel over the past year.

i have an userform which inserts into cell a2, a text field, say "membership income".(please note that cell a2 is variable) and cell a2 should be matched upto cells in column d.

how would u develop a macro that will check all the cells in column d equals a2 or not.

so if cell a2=dx then do not delete row x where x is the row number.

examples being....

if a2=d1 then do not delete row

if a2 does not equal d2 then delete row 2

if a2 does not equal d3 then delete row 3 etc

upto row 65536.

Cheers

Jay