I have been profiling a Excel solution I have built and have just discovered
that this particular statement ...

rngCell.NumberFormat = xlHAlignCenter ' where Dim rngCell As
Range

.... adds 0.61 secs of run time - when called only 2,000 times!!!!!

This is running on a W2Kmachine with Pentium4 2.8 GHz with 533MHz FSB and 1G
RAM - ie. no swapping!

Is working with Range object properties always this slow? Would using a
With rngCell statement and then performing all of the property updates in
one fell swoop speed things up?

Has any one found another way to whip this into shape?

Cheers,
Frank.