If your code changes worksheets or moves the screen (going to other cells), then
it hides those screen movements.

It's less disturbing to the user and actually makes your code work faster.



Judy Ward wrote:

I have "borrowed" subroutines from this site (that work beautifully) that have:

ScreenUpdating = False
<code that changes the values of cells here
ScreenUpdating = True

I was wondering what setting the ScreenUpdating to false and back to true is
doing for me. I looked in Excel help (it was no help).

I would love a simple (I'm not an advanced user) explanation.
Thank you,
Judy

--

Dave Peterson