Greetings all!
Is there a way to clear the cache by means of vba code?
i have noticed in 2007, it starts to lag doing repetative copy/paste routines. when we were 2003, this was not an issue but in 2007 this has become one. it used to take 30-60 seconds to run my macro and it now takes 3-5 minuets. the only thing that changed is the version :-\
i have looked around but i am not finding anything useful. any one have an idea?