Copy/paste macro is running slow

[Kaplan275]

Hi,

Following macro is running slowly (30 minutes). I have to copy paste several rows from each drop down box to new worksheet. However, each time calculations have to be made to get data for each drop down list member (there are about 760 members). I am sending the code below. Is there any way to make it work faster with alternative codes.

Thanks

Please Login or Register  to view this content.

[MarvinP]

Hi Kaplan275,

You need to try the "Destination" word in your vba. Look at http://www.tushar-mehta.com/excel/vb...acro_recorder/ and look at example 1 to see what I mean.

I hope this helps.

[Kaplan275]

Hi MarvinP,

Thanks for your reply

I actually ended up creating a long row with needed cells at the end worksheet (with formula) where my drop box information is located. Then I just copy that one row to the new worksheet. It is much faster now.

[Mallycat]

Try adding application.screenupdating = false at the start of your code, then set it back to true at the end of your code. You won't know yourself!