MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

My macro run to slow, How to speed up?

  Asked By: Muaz    Date: Oct 16    Category: MS Office    Views: 1522

When I run the macro the processing speed to slow.How to improve? Pls




2 Answers Found

Answer #1    Answered By: Carl Woods     Answered On: Oct 16

Maybe if you posted the code here someone could help?

Answer #2    Answered By: Adal Fischer     Answered On: Oct 16

When we see your code we could give specific advice, however general causes of
slow macros are:

Using the selection object rather than a range object
Not turning screen updating off
Not turning calculation off.

Didn't find what you were looking for? Find more on My macro run to slow, How to speed up? Or get search suggestion and latest updates.