Greetings,

I have a macro that I run in excel 2007 and for some reason it will vary in speed. I have a large excel file with over 30,000 rows that need to be updated by this marco. Yesterday when running it, it was completing about 100 lines per minute. Now it is completing only about 10 lines per minute. Yup, it's running 10x slower than it did yesterday. I tried saving the file and closing out excel, then reopening. That didn't work. Then, I tried shutting the computer down and opening up the file. Still didn't work. So my questions are:

1. What controls this seemingly random change in speed?

2. How can I get my macro to run FAST every single time?

As you can imagine, updating 30,000 lines takes a long time with this complex macro, but it is better to run 100 a minute than 10 a minute.

Any ideas what I can do to remedy this issue?