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.

Hi
could you post a sample of your sheet and your code please?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post