Hello all
I have this short line of code that removes duplicates rows based on the cell values in column "A"
This works fine but I need to delete from row "A" downwards instead of last row upwards
Any idea's please on how to change the code to delete from the top down instead of the bottom up
I have this short line of code that removes duplicates rows based on the cell values in column "A"
This works fine but I need to delete from row "A" downwards instead of last row upwards
Code:
b = Cells(Rows.Count, 1).End(xlUp).Row
Range("A1:Z" & b).RemoveDuplicates Columns:=1, Header:=xlNo
Any idea's please on how to change the code to delete from the top down instead of the bottom up