Optimizing VBA

Glad it worked for you. Now you just need to work on speeding up the other macros.

:beerchug:

Thank you Jake,

I must admit I would have never done that without help, thats for sure!:bow:

Hi John,

I did as you suggested and it made my system faster.

Thank you very much!:bow: :bow:

Quote:

---

Originally Posted by johnske

If you dont already have it, click this link > ToniArts EasyCleaner then download and install EasyCleaner (it's free), then click "Unnecessary" and tick all the items in there - run it and delete all that's found. Then Click "Registry" and delete all the items found (dead links etc) in there. (It's amazing how much unnecessary junk can accumulate in your machine in just a few days, slowing it down and fragmenting the info on your hard-drive).

Now defrag...There are many defraggers around, the one I use personally is Diskeeper Lite (it's free also) - it's MUCH faster that the inbuilt one (Win97SE) and does a far better job. However I'm led to understand that Microsoft bought and uses the Diskeeper program in their latest versions of Windows so you may already have this installed...

After doing all this, try running the code again.

Regards,
John

---