Im using VBA with excel to do some routine totaling of large amounts of data that come in every month in more or less the same format...

While im writing the code im also testing it to make sure it runs smoothly, but, once i write a function and test it it goes REALLY slowly. One time I got kinda....bored...and ctrl+alt+deleted to end task. When i reloaded the SAME file (had saved just before testing and ending) it goes signifcantlly faster, like ~30x faster.

My question is, why does it do this and how do i make it do that WITHOUT having to EndTask and come back.

NOTE: saving and closing out the file doesn't work either.

Thanks,
-Andrew