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