LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default 2007 Merge cells taking forever

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Taking away from stock in excel 2007 Rich Excel Discussion (Misc queries) 1 January 31st 10 11:08 PM
Excel 2007 conditional format and merge cells PeterHS Excel Discussion (Misc queries) 0 June 17th 08 04:41 PM
Excel File Taking Forever to Open MEAD5432 Excel Discussion (Misc queries) 5 June 11th 08 08:58 PM
Calculating Cells Taking Forever Jason Excel Discussion (Misc queries) 2 September 14th 06 07:13 PM
mail merge- & data source - only taking 1st name in the list harriet Excel Discussion (Misc queries) 6 February 21st 05 01:20 AM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"