Slow data input post formatting

P

PukiVruki

I have a database from which I pull data.

Everything is done via VBA. When I call my formatting functions AFTER
I've input all the data, then the process goes quickly and moves on to
another file.

Although when I request that the formatting (borders, colours [no
formulas]) be done prior to the data output (mostly done via
CopyFromRecordset or direct cell output) then the whole process slows
down immensly.

I have to format some of the columns independently - hence wanted to
format the whole sheet first, and then customize which I need. That's
the reason behind wishing to format it first.


Any ideas as to why this may be so? ScreenUpdating has been turned off
upon the creation of the file.

Any tips appreciated,

Thanks
 
Top