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 i
to.

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

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

What I'd like is to disable the update region for the sheet, wait fo
the process to complete, then enable the update the region and have th
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

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/

.