View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Madiya Madiya is offline
external usenet poster
 
Posts: 239
Default 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.