how do I compare the value of a cell to a different cell
How do I compare the value of A2 to A1 in a macro?
I have 7,000 rows of text. Many of lines have the same
information as previous lines. Ultimately, I want to
delete the rows with repeated information. (I know how to
do that.) But, I want to compare A2 to A1 to see if the
text is the same. If it's the same, I'll delete A2 and
then compare the (new) A2 to A1. If it's different, then
I'll move to A3 and compare that to A2, etc.
I figure it's got something to do with ActiveCell.Value
but I don't know how to refer to or evaluate
the "previous" cell within the macro command.
Thanks.
|