Macro for excel 2000 that will search a column

[gramaw]

Can somebody help me to write a macro for excel 2000 that will search a column of choice for duplicate records, then delete all duplicates it finds, including the original, and the corresponding information in their rows. For example, if the records in a row were a, b, c, c, c, d, e, once the macro was finished the only records left would be a, b, d, and e. it will need to delete all instances of c, and the corresponding information the row.

Ryan

 

[TonyU]

[tt]
Ask DaleWatson123321 at the VBA forum

[tt]"A Successful man is one who can build
a firm foundation with the bricks
that others throw at him"
[/tt]

​