Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Office XP with Office 2007.
I have a severe slow down in my code when using any For Each...Next structure, such as "For Each Cell" or "For x = 1 to 10000"... This slow down seems to be only in Office 2007. In 2003, my code runs like a machine gun; in 2007 it's more like a burp, wait a second, burp, wait a second...etc. This is the same code on the same machine so I'm sure my code is not to blame since it has always run fine in 2003. At this pace, a program that used to run in a few seconds could now take several minutes. Has anyone got a fix or any ideas how to make it run faster? Thanks much for your assistance/guidance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Very slow Visual Basic code execution in new Excel 2007 | Excel Programming | |||
2003 2007 Code | Excel Programming | |||
visual basic code runs very slow in 2007 | Excel Programming | |||
why is moving a row slow in excel 2007 where it is fast in 2000 | Excel Worksheet Functions | |||
Slow code when used as VBA code instead of macro (copying visible columns) | Excel Programming |