View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 2007 Merge cells taking forever

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