InputBox to Select Cell for Paste Special

I have copied data from a selection of cells and then using one of the two sets of code to paste special the data.

The code below allows me to select the cell to paste special but the pasting comes up with an error:

Please Login or Register  to view this content.

With the code below (where 1Rng is the last pre-selected cell in a column – the default paste cell) the paste works but I can’t select another cell.

Please Login or Register  to view this content.

How can I modify the code to allow for cell selection and get the paste special to work?
Thanks Sandy

I tried to simplify the code to make it easier for the post! I am using the following code for the copy from one worksheet:

Please Login or Register  to view this content.

I am then going to another worksheet for the paste.
I am unsure how to work the above into your code?

Thanks I will give that a go tomorrow.

Alpine skiing combined ...
You can also do this that way:

Please Login or Register  to view this content.