This macro will delete rows that appear twice in a list or worksheet. If two cells are identical， this macro will delete every row with an identical cell which is underneath the first occurrence. The first instance will still remain， but all identical cells in the rows underneath the original cell will be deleted. In order to run the macro， you need to select the entire column where you want to search for duplicates and then run the macro.我20多年的VBA实践经验，全部浓缩在下面的各个教程中:
