Hello all
This line of code removes all my duplicate rows based on the primary key in column "A", at the moment it deletes from the last row upwards but I need it to delete from the first row downwards, reason being is that the newest records are always copied after the last row, is this possible please.
This line of code removes all my duplicate rows based on the primary key in column "A", at the moment it deletes from the last row upwards but I need it to delete from the first row downwards, reason being is that the newest records are always copied after the last row, is this possible please.
Code:
Cells.RemoveDuplicates Columns:=Array(1)