Try

Application.ScreenUpdating = False

at the start of the loop - change it back at end

Peter Atherton

-----Original Message-----

I know from my C++ windows coding there is a concept of -
Update Region-,
where I can essentially turn off updating the screen
until I tell it
to.

When I want to do is stop the (imho) ugly way a sheet
updates as a
calculation is in process. My application reads a bunch-o-
data from a
couple of external data sources, then weeds through and
consolidates
parts of the information, puts that information into a
table or two and
charts it.

The problem is as the weeding, consolidating and
chartings procedures
are running, the screen is performing a live update of
the tables and
charts. You see the table being filled and the chart
series being
added. Not too professional looking.

What I'd like is to disable the update region for the
sheet, wait for
the process to complete, then enable the update the
region and have the
sheet update in a single vertical retrace.

Possible? Anyone know how to accomplish this?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.