Results 1 to 5 of 5

Is there anyway to see why ScreenUpdating is taking so long?

Threaded View

foxguy Is there anyway to see why... 10-11-2011, 02:40 AM
Bob Phillips Re: Is there anyway to see... 10-11-2011, 03:09 AM
foxguy Re: Is there anyway to see... 10-11-2011, 03:37 AM
romperstomper Re: Is there anyway to see... 10-11-2011, 03:43 AM
foxguy Re: Is there anyway to see... 10-11-2011, 04:17 AM
  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Is there anyway to see why ScreenUpdating is taking so long?

    I turn off ScreenUpdating at the beginning of all Events, and turn it back on when it's done.

    I have managed to determine that when ScreenUpdating is set True that it takes longer than I like.
    I know that turning it on automatically triggers a calculation, which I assume is the reason it takes longer than necessary.
    Is there any way to determine what is being calculated? And more specifically how long each formula is taking?

    I'm guessing that turning ScreenUpdating to True and back to False while the macro is running would not help when the macro ends. Is that right?

    BYW: I've seen several people say that ScreenUpdating automatically gets set True when the macro ends, but the help file says that it doesn't.
    Last edited by foxguy; 10-11-2011 at 04:18 AM.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1