You need to loop through a range with a counter, test if the current
item is the same as the last one and if it is delete it.
The following code works for me.
Be aware that if you delete the row then the selected range will stay
the same size. Also.. the code starts with A1.