John,
I do this all the time and don't understand your tip. Since I am in control of my macro and updatinog, I turn it off when a long macro is doing screen ops, then turn it on when the macro finishes - this way it runs faster, then, I see the results when it finishes.
Even if it was off to start, I still want to see the results.
Steve
--- "VisioMVP" <VisioMVP@...> wrote:
>
> One minor point. Rather than setting ScreenUpdating to True at the end, you
> should save the current state and then restore it when finished. If
> ScreenUpdating is false before you start, then you would be altering things.
>
> John. Visio MVP
>
> From: mickey11030>
> Thanks all; that will be a big help.
>
> --- William D Simpson <w-simpson1@> wrote:
> >
> > Application.ScreenUpdating = False '.to stop screen updating
> > Your code here
> > Application.ScreenUpdating = True '..to allow screen updating
> > Regards, Bill Simpson PMO Emerging Programs 972-952-2573
> > From: "mickey11030"
> > I seem to remember hearing about a command to stop the window from
> updating
> > to speedup a long running macro. Does anyone remember what that command
> is?
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar