Visual Basic / Jumping Screens....

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?
 
D

Dan E

Jerry,

At the start of your macro
Application.ScreenUpdating = False

At the end of your macro
Application.ScreenUpdating = True

Dan E
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Rows with values in column A pasting in a new doccument and saving that doc 1
VBA Macro Training in Chennai 0
Data filter and deleting rows in visual basic 0
Copying macros to another workbook 2
Creating a variable range in Visual Basic 2
Flickering screen while processing macro 5
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Trying to create Macro to search the Internet Movie Database 0

Top