Error on code to copy and paste user selection.

**leaning** · 09-16-2011, 10:35 AM

Hello!

I fudged together some code to copy a user-selected range to another user-selected range on the same sheet.

I am getting a "400" error...?

Also, if anyone sees anything else that would make this code less clunky, I would appreciate the help!

Please Login or Register  to view this content.

Respecfully,

Lost

**tigeravatar** · 09-16-2011, 11:23 AM

leaning,

Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**leaning** · 09-21-2011, 03:58 PM

All,

My other thread sums up how this code and information gets applied.

http://www.excelforum.com/excel-prog...-the-copy.html

HTH!

Lost

**MFO_Jester** · 11-03-2011, 10:52 AM

I don't mean to bring up a dead post but this helped me out tremendously for a schedule spreadsheet we keep at work.

The only thing that I am trying to figure out is how to clear the contents of the original cell (CopyFromRange) at the end of the macro.

Can you help?