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.