Input box not collecting range object

I am trying to use an input box to collect a range of data from one open workbook and paste into the next unoccupied cell range in another. The input box does not seem to be collecting the data. Also I'm not sure that once the data is collected it will paste into the destination workbook!

Many Thanks!
code is:

Please Login or Register  to view this content.

Try using

Please Login or Register  to view this content.

without the Select.

If you want to remove Select from all the code, this routine should do it.

Please Login or Register  to view this content.

Thanks Mike!
I've just sussed it!

Please Login or Register  to view this content.