LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Long running macro and screen update

I may be completely off track but often flickering is caused if you are
selecting cells, sheets etc rather than accessing their values
directly.

If you're not doing that another idea would be try
Application.ScreenUpdating = False (then set it to true when you're
finished)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide screen movements when a macro is running STatAGL Excel Discussion (Misc queries) 4 April 3rd 23 06:54 PM
Status bar (or similar) to appear whilst running a long macro Ant Excel Discussion (Misc queries) 8 November 11th 05 09:21 AM
running a macro on every refresh of the screen shovit sahai Excel Programming 5 March 2nd 05 10:56 PM
How to stop screen blinking when running macro Stephen[_6_] Excel Programming 1 June 3rd 04 11:51 AM
Eliminate screen flashing while running a macro using VBA in Microsoft Excel. abbeville Excel Programming 1 May 21st 04 02:11 PM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"