screen flashing on macros

[canablitz]

hi, ive got a macro to add data from one sheet to another, and i know there is a line to put at the top of the macro to stop the screen flashing, but i cant remember what it it (something like "screen update" or something)
so if anyone could tell me the line, ide be very gratefull

thanx BoB

 

[lenze]

Application.ScreenUpdating=False

 

[KniteMare]

Just make sure to put:

Application.ScreenUpdating = True

as the last line of your code or the screen could remain blank when the macro is done running!!

Yours in EXCELent Frustration
KniteMare

 

[Mark O'Brien]

On 2002-04-01 07:29, KniteMare wrote:
Just make sure to put:

Application.ScreenUpdating = True

as the last line of your code or the screen could remain blank when the macro is done running!!

Yours in EXCELent Frustration
KniteMare

So long as control is returned to Excel at the end of the code, you don't need to put this line in.

for example, if you push a button on a userform to perform some operation that turns off screen updates, when control returns to the userform you will be able to drag it all over your screen and paint pretty Userform pictures all over it.