Macro to keep first instance and remove duplicates in certain column
Hi All,
I have the macro below that I run on several worksheets with no issues. But on all of them it runs on Column "A". I need to modify it to run on a different column on a new worksheet but I am not having any success. Can someone help?
Sub luxation() Dim N As Long N = Cells(Rows.Count, 1).End(xlUp).Row For i = N To 2 Step -1 If Cells(i, 1) = Cells(i - 1, 1) Then Cells(i, 1) = "" End If Next i End Sub
|