I have a data base of addresses for homes. The data is repeated in many
cases based on previous listings or sales, and I want to only save the
latest record, deleting the earlier ones.

I've sorted the data based on date, and would like to delete row( i ) if the
text in Cell(i,1) is the same as the text in Cell(i-1,1)

I've made a few attempts, but have had no joy.

This seems like a pretty trivial exercise - I only need what would be in the
if...end if portion.

Any suggstions would be appreciated

Thanks,
Jim