(Solved) – RemoveDuplicates; selecting the copy to keep

  • by
(solved)-–-removeduplicates;-selecting-the-copy-to-keep

I am using the RemoveDuplicates function to delete rows that have the same values in column 2-4-5-6-8 and 9, using the code shown below. The problem using this function is that it deletes the last instance. I have a column that may have some information in it, and I want to keep the row that have that information. I was wondering if there is a simple way to do that using this function.

        .Range("A1:M" & lastrow).RemoveDuplicates Columns:=Array(2, 4, 5, 6, 8, 9), _
        Header:=xlYes

Leave a Reply

Your email address will not be published. Required fields are marked *