Microsoft had a posting at this site in late December asking for uses with
speed problems in 2007 to submit their macros to help microsoft fix this
problem.

"Alain-79 (SQEpro)" wrote:

Hi,

I have been working for several years on a rather big Addin and have already
improved the vba code several times regarding speed... puting to xlmanual the
calculation, screenupdating to false, using intermediates arrays for pasting
large amount of data on spreadsheets... working only inside usedrange...

One of the most important function of this application takes around 30
seconds on Excel 2003... And this "performance" have been aquired after
several code improvments...

I have started recently tests under Excel 2007 and the result is not that
pleasant = around 50 seconds!!!

I had the feeling that all of standard actions normaly requested regarding
speed was already taken... but have now the strong feeling I was wrong...

Any idea ? Would I be the unique one to face such speed problems...

As an example, I manipulate paste format inside a loop and I do that for the
all line while it could be done for only a few columns... Was not a problem
with 2000, 2002, 2003 // Could it be a problem with 2007 because of the
number of possible columns while I am still in compatible mode?

Whatever you can tell me about speed problems with Excel 2007 can help...
Thanks to you
Alain...

my Addin is around 50k line code...