Visual Basic / Jumping Screens....

  • Thread starter Thread starter Jerry Doran
  • Start date Start date
J

Jerry Doran

I've created macros to get information from other files,
they open files, filter data, then copy filtered data,
then go to an existing file, to paste, etc....

This causes some eye strain with the flickering effect of
the macro running....

Can I change this flickering effect by causing visual
basics to lock in on one page or another, while the macro
does its work in the background?
 
Jerry,

At the start of your macro
Application.ScreenUpdating = False

At the end of your macro
Application.ScreenUpdating = True

Dan E
 
Back
Top