I have a macro that as part of the code deletes duplicate rows based on 3 of the columns, or it should. If I am running it with VB window open it works. If I just click the 'button' to run the macro it just ignores the line to delete the duplicates.

The rest of the macro runs, but of course the results are rubbish because I have 4 times the lines that I need.