Hi all,
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
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