Copy from 1 sheet to another

S

SDeVuyst

I have some data on my main sheet and I want some of it to be automatically
copied onto another sheet. I have got it to work, using a macro, but my
screen flickers when it jumps to sheet 2 and back again. Is there a way of
not having the 'flicker'?
 
N

Norman Jones

Hi SDeVuyst,

Try:
Application.ScreenUpdating = False
'Your code
Application.ScreenUpdating = True

Or, better still, rewrite you code to avoid making selections or switching
sheets.
 
Top