• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA runs slow first time

Hi everyone,

I have a macro that just transfers the data from a user form to a sheet. Everytime I open it and run the macro it takes 2 mins 30 seconds for First time. If I run the macro without closing it again, it takes only 20 seconds.....I have tried all the solutions available on the internet..No use...Please help
 
Hi !

That's normal 'cause when any procedure is launched again
all data are already in cache memory !

So nothing specific to VBA, just computer basics …
 
Hello Sandy...As suggested by Marc....data are already in cache memory ...that is why taking less time for second time....please upload your file to see... How we can reduce further time on first time.
 
Hi Friends...I managed to reduced the time of 2 mins 30 seconds to 20 seconds even first time...by releasing all the objects at the end..
 
Back
Top