Hi, I've set up my spreadsheet so that at the click of a button it will check
all of the entries for any duplicates. Unfortunately there is more and more
data on the sheets each week and this slows down the duplicate checker.

I assume this is because it is somehow filling up the computers memory, and
the easiest way to sort it would be to dump the unneeded data it might be
storing after each section of the search.

My questions being: what is the best way to do this; is this the best way
to sort it out; will this get rid of the variables i need to keep (ie if
sheetscan = 3 then sheets("Progress") activate - to scroll through the
sheets)?????

Any help will be greatly appreciated.

TIA
Jonny