Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

How can I make the screen stop flashing during macro execution?

MS Excel Interview Question
MS Excel Interview Question

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
In visual basic, I can set the color of a cell with the .interior.colorIndex property. How can I read the color of a cell before I change it?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.?