Microsoft Excel Question:
Download Questions PDF

How can I speed up my Macro execution?

Answer:

Turn off the screen updating during macro execution. Insert this line at the beginning of your macro:
Application.ScreenUpdating = False

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How can I get Excel to accept an entry like "5+5" without the leading equals sign as a formula? I have done this is the past but can not remember how.?How do I have EXCEL execute a macro automatically upon starting EXCEL?