changing number format doesnt trigger change event nor recalc's..
so the .61 secs looks suspicious.

BUT

in my experience the bottleneck just might be the display of
pagebreaks... (which takes time regardless of screenupdating)

have you (double)checked that display pagebreaks is OFF?
(both auto and manual)...

for new sheets, you must force a preview when the sheet is still
unpopulated and THEN turn if off.

hth


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?QXNobGV5?= wrote:

Frank,
It might be better if you use an Autofilter to do blocks of cells at a
time. Eg, turn Autofilter on, filter for blank cells only, change
format for all cells in the range, and it will only change the
filtered cells.

Regards,
Ashley

"Frank_Hamersley" wrote:

"Charles Williams" wrote
Try to set Range properties once for as large a range of cells as
possible rather than one cell at a time. And using With or Set will
also speed things up.

Thanks for the hint Charles - I suspected that bulk operations might
be the way to go! Unfortunately the app tries to set the best
possible cell format based on the Value in each cell.

I had thought of doing EntireColumn formats, but there is no
guarantee that the most representative cell value occurs on the first
row after the column titles la la la. This is because some of the
data comes from a database server and may contain NULL's etc ie.
hetrogenous values and I try to present the best format possible.

Anyway I guess I'll have to do something 'cos I don't expect Excel
(sic) will pull its finger out!

Cheers, Frank.