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!

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment