Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taking away from stock in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 conditional format and merge cells | Excel Discussion (Misc queries) | |||
Excel File Taking Forever to Open | Excel Discussion (Misc queries) | |||
Calculating Cells Taking Forever | Excel Discussion (Misc queries) | |||
mail merge- & data source - only taking 1st name in the list | Excel Discussion (Misc queries) |