Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why would Excel react this way to this process?
Hi fellow Guru's... I am curious as to why the following is causing my
macro to slow down after it loops like 50 times... I have written some code to do the following... 1. Delete a sheet called "DataPull" and create a new spreadsheet called "DataPull" 2. Conduct a web query from a website 3. Manipulate the imported data and export it 4. Jump down to the next cell 5. Go back to step # 1 Rinse and repeate... the problem is the code is lighting fast up until the 50th loop. I don't understand why it would slow down if the process didn't change after the first 49 numbers. The only thing that is changing is the spreadsheet # when it's created. Anyone have any idea as to why this would slow the macro down to a crawl once it hits the loop at 50? Much appreciated! -Shaka215 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver doesn't seem to react | Excel Discussion (Misc queries) | |||
Multiple Charts That React to Custom Excel Filters? | Charts and Charting in Excel | |||
Userform doesn't react on enter | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming |