Variable Execution speed of VBA Code

S

SlipSleepy

I have a macro running in the background of Excel. For a while, it was
running very fast. Then, w/o changing anything (that I can figure out, at
least), it started running at about 5% of the former speed. Then, again w/o
making any real changes, it started running more quickly. I was thrilled for
a day, and now it is back to its bad habits. Any thoughts? Is there a
compiler in the background that I am unknowingly turning off/on?

Thanks in advance
 
N

NickHK

It will depend on the other running tasks that are occupying the CPU at that
time.
Any virus scan, back up, network stuff going on?
What about file Indexing ?

If you slow/fast Excel setups are the same, look at what the OS is doing ?

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

execution speed issue when closing files 5
VBA word change keys 0
wildly varying execution speeds - is it the code? 3
any ideas why execution speed varies? 5
Using Code Editor Slows execution speed 1
Slow execution changing cell value 4
Display one sheet or two userforms while code is vba code is runningon another 2
Message while macro is executing 3

Top