VBA Inputbox

I attached a small example of what im trying to do here but bear with me im just getting started in VBA... Macro2 is suppose to copy the specified range at the start of the macro then the user is suppose to point to the destination where they want it pasted with the inputbox... as you can see when you run this macro it's not quite working... just wondering if anyone could amend it for me and maybe briefly explain where im going wrong if its not too time consuming??

Please Login or Register  to view this content.

I'm not sure what you mean by "not working".
There is a problem if the user presses cancel.
If the user selects a range that is smaller than A2:B34, but lager than one cell, not all of A2:B34 makes it to the new location.
On my test runs, its copying values and formats but not formulas.

This addresses all three of those.

Please Login or Register  to view this content.