Speed

[MikeH2]

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?

 

[JLGWhiz]

If you are leaving various files open during the day, certain things are
retained in memory until the file is closed or Excel is teminated. Memory
storage can accumulate and cause slow processing since each previously stored
datum is checked to see if it applies to the current process. It does not
hurt to periodically shut Excel down and restart when you are going to run a
big procedure or do a lot of calculations.