Is it possible to modify this macro to work on any column? It seems to only work if my data is in column "A".

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