Tom Ogilvy wrote:
Set calculation to manual at the beginning of your macro and back to
automatic at the end.

Thanks Tom,


I tried that and it did not seem to make much of a difference.

But just tried it again and I can see that it does make a little
difference just not huge. I am writing about 10000 rows X 8 columns so
that is a lot of cells.

Any other performance ideas?