Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can somebody help me with a slow macro problem.
I have a macro that has suddenly slowed down to a crawl. I turned
screen updating off to watch it, and simple loops can be followed @ about 2 per second or so. I've tried it on several different computers and the same thing happens. All calculations are done in the macro, so calculating cells isn't a problem. This thing has slowed down from maybe 20 secs or less to ten minutes. I really can't figure out whats going on as all my other sheets do just like normal. Also, if I add a test macro with a simple loop through cells it works fine as well. The workbook isn't large. The code is in a form, could that be the issue? Something else I've ust noticed is if I run the macro, and leave the workbook open, and then run a different macro in a different worksheet, it slows way down also. I'm completely stumped. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slow copying problem | Excel Worksheet Functions | |||
D-sum and Grouping slow down problem | Excel Worksheet Functions | |||
Very Slow Macro Problem | Excel Programming | |||
Problem with Slow ReCalculation of Dynamic Range Using OFFSET | Excel Worksheet Functions | |||
Strange problem - extremely slow application. | Excel Programming |