disable update screen?

[dianahatesboys]

hi! first post here
what command do i need to use in vba to make it so that the sheet doesn't continually "blink" or update while i am running a macro? i know there is one i just can't think of it.
Thanks!
- diana

[Carim]

Hi Diana,

At the begining of your code

Please Login or Register  to view this content.

At the end of your code

Please Login or Register  to view this content.

DoBoysHateDiana ...

HTH
Carim

[dianahatesboys]

thanks for all your help carim! i'm sure i'll be needing it again