I run a lot of code that will analyze large amounts of data, both in text
files and in other spreadsheets. Typically I populate an array with one set
of data and then go to the other set of data and compare the information and
keep a list of differences. The issue is speed. If I first open excel and
run one of these subs it goes pretty fast. But later in the day, I will
rerun the same sub and it is EXTREMELY slow. There may be other things
loaded in Excel and I have noticed if I kill the process, close excel and
restart it, I get the same speed I did initially. Is there another way to
get the same effect without closing excel and restarting it?