Flickering Screen

[Pimafix]

How do I get the program to run so that I can stay with a screen that doesn't move? I would like to get the data to update in excel without the screen flickering and I want to see the data populate, not freeze the screen.

 

[SkipVought]

Hi,

In your Excel procedure, use application.screenupdating = false before your code and then application.screenupdating = true after.

Skip,
[sub]
[red][/red]
[/sub]

 

[calculus]

Turning the screen updating to false will not allow you to see the update until the program is finished.

I use this:
cells(3,4).value = "My Test"
This gives you the ability to reference any cell by Row and Column.

If you put in "doevents" through out the code in the correct places you will not see Excel lock up.

You should also note that if the user then tries to type in a cell while the macro is running it will cause problems with your code.

calculus

 

[Skie]

Also, the screen should only move if your code is selecting a cell/range. Sheets(1).Range("A1000").Select

 

[SkipVought]

You want to SEE the data populate.

Slows things down.

Why not use the Statusbar to post progress.

Also do NOT use the Select and Activate methods.

Skip,
[sub]
[red][/red]
[/sub]