How to Avoid Screen Updating in Excel VBA?

This article helps to handle the screen updates using macro. We can speed up our macro by turning off the screen updating while the macro runs, by adding the below line of code to the macro:
Sub Macro ()
Application.ScreenUpdating = False

Write the necessary code Here


Application.ScreenUpdating = True
End Sub.

The prior versions of excel 2000, it was not

buy viagra canada

required to turn ScreenUpdating back to

buy viagra online without a prescription

true. When the macro is finished, Excel would revert back to turning the screen updating to true.

But now whether you are writing macros in Excel 97, Excel 2000, Excel 2002, 2003, 2007 or 2010 always we have to turn the screen updating back to true with the below code:
Application.ScreenUpdating = True

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis, Excel Invoicesand Excel Bid sheets. You can contact us by email: cs [at] or call us at 305.600.0950.

[Bloglines] [] [Digg] [diigo] [Facebook] [Furl] [Google] [kirtsy] [Ma.gnolia] [MySpace] [Propeller] [Reddit] [Simpy] [Sphinn] [StumbleUpon] [Technorati] [Windows Live] [Yahoo!]


  • By T shirt printing, May 19, 2014 @ 11:32 pm

    Quality artixles or reviews is thhe crucial to invite the viewers to pay
    a visit the web page, that’s what this website is providing.

  • By Latrice, September 19, 2014 @ 3:05 am

    Hi there this iis somewhat of off topic but I
    was wanting to know if blgs use WYSIWYG editors
    or if you have to manually code with HTML. I’m starting a
    blog soon but havee no colding expertise so I wanted to get
    advice from someone with experience. Anyy help would be greatly appreciated!

  • By t shirt shop nashville tn, January 19, 2015 @ 4:30 am

    hello!,I like your writing so much! share we be in contact extra approximately your post on AOL?
    I require an expert in this house to solve my problem.
    Maybe that is you! Having a look forward to look

  • By custom name university t shirts, January 21, 2015 @ 7:38 am

    excellent issues altogether, you just received a new reader.

    What could you suggest about your publish that you made a few days ago?

    Any positive?

  • By Lucienne, January 25, 2015 @ 1:05 am

    Aware Bear Computers (585)473-7035 on 5 Monroe Avenue Pittsford NY
    reviewed the new HP ENVY 14 Beats Edition Series. If you happen to take your PC in for repair, get full information about the store and
    their records from those who have acquired their professional.

    It can be challenging to find qualified technician providing affordable services;
    however, with moderate research and web browsing, you will be able to find a suitable technician.

  • By dilioptim, May 2, 2015 @ 12:36 pm

    I like the helpful info you supply in your articles. I’ll bookmark your weblog and test once more right here regularly. I am quite certain I’ll be told many new stuff right right here! Good luck for the next!

  • By dili optim, May 2, 2015 @ 12:42 pm

    wonderful points altogether, you simply won a new reader. What would you suggest in regards to your put up that you just made some days ago? Any sure?

  • By make your own t shirts, May 9, 2015 @ 4:56 am

    I do consider all the ideas you have presented in your post.
    They’re really convincing and will definitely work. Still, the posts are too
    brief for beginners. Could you please prolong them
    a bit from next time? Thank you for the post.

  • By Porter, July 8, 2015 @ 9:28 pm

    Asking questions are truly good thing if you are not understanding something completely, however
    this article gives fastidious understanding even.

  • By mobil, July 18, 2015 @ 2:18 am

    Stories and i can state pretty good stuff. I will definitely bookmark your blog.

  • By Game Guys Naples, October 6, 2015 @ 12:12 am

    Merely place, the higher the DPI, the additional your cursor moves
    with minimal mouse movement, and vice versa.

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment