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.

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.

Macro speed decreased now to great extent
 

Thanks but its already there in the code.
Regards,
Madiya
`
wrote:

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.