I actually have determined what the slow down was.

I did test this on both Excel 2003 on a vista machine, and Excel 2007 on
both a Vista and an XP machine. It is definitely a problem with 2007.

I can tell you that this block of code:

With rngMergeInfo
.Merge
.Font.Italic = True
.Font.Size = 10
.VerticalAlignment = xlCenter
End With

took 13 seconds to process. But what I failed to mention is that the sheet
has a lot of small .png pictures. They are almost all hidden and I unhide
them when needed. Now in 2003 the code had no problem, but there must be a
major difference with how 2007 works with hidden pictures as when I deleted
them all and ran the code, there was no slowdown.

Now I positioned the pictures with their left in the right spot so that I
wouldn't have to set the left property programmatically. So I'm hoping if I
move the pictures to a part of the sheet that won't have cells merged, that I
won't have the slowdown.

Any thoughts on how Excel handles the pictures differently?


--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003



"Rick Rothstein" wrote:

Can you post your code so we can test it on different systems to see if it
is universal or operating system dependent? I'm using Vista myself, but I
know others are still using XP, 2000, etc. Also, which operating system are
you using?

--
Rick (MVP - Excel)


"J Streger" wrote in message
...
It seems that every time I try to merge cells via VBA, it takes forever.
Code
that ran in 1 second in 2003 is taking over 10 seconds in 2007, and Excel
is
stating it is Not Responsive so even the status bar is not updating. I
tried
to pull all of the merging out of my loop and do it in one line, thinking
that this would be faster, but alas it seems the merging time is
proportonal
to the amount of sections I'm merging. Anyone else have this issue and
know
how to fix?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003