Question: What if A2 is NOT equal to A3 but equal to A4 (and/or A5...)
Do you also delete A2? (My question seems silly, but, I've thought of
scenario where this might be an issue...)

carlito_1985 Wrote:
Hey everyone, I need to write a macro that checks if cell a2 is equal t
cell a3, and if so, deletes the entire row (the one that a2 is par
of).
I need this to run down about 1000 cells and continue to check an
delete, so i need it to be something like
if a2=a3 then 2:2 delete, if a3=a4, then 3:3 delete and so on, but i
there a way to automate this so you can assign the macro to a button
and when you click it it goes through the list checking and deletin
rows?
Thanks guy

--
T-®e
-----------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=39936