Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro speed decreased now to great extent
I have a macro that imports data from web and puts it in a data sheet.
This works with a great speed. No problem. From there it finds the relavent data and copies it to proper cell in another sheet. There are approx 30 to 40 rows with 15 col to be copied cell by cell. Here I am using find and copy statements. Earlier this was working properly in about 5-6 seconds but from last few weeks, it takes more then 3 min to complete. This is a big problem and mystery for me. I have not installed any new softwares or altered my system in any way. Can someone thorw some light please to restore the original speed. Regards, Madiya. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro speed decreased now to great extent
Hi,
Application.ScreenUpdating = False in the begining of the macro will speed things up but remember to set it back to true at the end of the macro regards, julian Madiya wrote: I have a macro that imports data from web and puts it in a data sheet. This works with a great speed. No problem. From there it finds the relavent data and copies it to proper cell in another sheet. There are approx 30 to 40 rows with 15 col to be copied cell by cell. Here I am using find and copy statements. Earlier this was working properly in about 5-6 seconds but from last few weeks, it takes more then 3 min to complete. This is a big problem and mystery for me. I have not installed any new softwares or altered my system in any way. Can someone thorw some light please to restore the original speed. Regards, Madiya. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro speed decreased now to great extent
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 SP1 - How to correct scrollbar extent? | Excel Discussion (Misc queries) | |||
Have this great Macro, but!! | Excel Programming | |||
Finding decreased value PLEASE HELP ASAP! | Excel Worksheet Functions | |||
Improvement to sub: Detect data extent and convert to values | Excel Programming | |||
Defining Range Extent | Excel Programming |