Hello,
I have a macro in excel 2003 that reads a value from a cell on one
worksheet, processes it, and records the result into a cell on another
worksheet. The trouble is, it does this for hundreds of cells and when I
run the macro the spreadsheet flicks between the sheets until the macro
terminates. This looks very ugly.

Is it possible to stop the screen updates at the beginning of the macro
and then, when all the calculations have been done, let the screen be
updated?

I hope this makes sense.

thank you