Streamlining Macro Code

[SinGin]

I have a bit of code that pastes the copied selection in 100 different cells. See below for a small sample. I am looking for a way to streamline this so that the macro runs quicker. Is there a way to have the copied selection pasted in 100 different cells without writing the cell destinations on a hundred different lines?

Please Login or Register  to view this content.

[Marcol]

This should do what you need

Please Login or Register  to view this content.

Expand the range as required

Hope this helps

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[SinGin]

Thanks, worked great!! In a related question, I tried to get this to work by modifying the code you gave me, but no luck. This code selects and deletes 100 ranges of cells. Is there a way to accomplish this all at once?

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

... or just

Please Login or Register  to view this content.

[SinGin]

Awesome. Thank you very much!!