Flickering Screen

[Pimafix]

How do I get a 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 or moving and I want to see the data populate, not freeze the screen.

 

[SkipVought]

Hi,

Use application.screenupdaing = false as the first statement on your macro and insert one in the LAST statement = TRUE.

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

 

[SkipVought]

application.screenupdating = false

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

 

[firefytr]

Here are some other resources you should take a look at...

http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm

http://hacks.oreilly.com/pub/h/1288

http://www.mvps.org/dmcritchie/excel/slowresp.htm

A Google search will yield many results as well.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[SkipVought]

Avoid using the Select and Activate methods.

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