Inputboxes to select range to copy and range to paste from different workbooks

Hi,

I'm writing a macro that will allow users to import data into a sheet. The way I've set it up I'm wanting to lock the sheet down so that the only way end users can update the values is through following the process I've set out in the macro. Generally the data will be coming from a standardised summary template from a different workbook (which I've gotten to work), but I've been trying to build in a back door that will allow the user to manually select where this data comes from and where to manually paste it using inputboxes (incase something gets changed in the future it means they'll still be able to use the import function without the macro breaking). This is the part I'm struggling with. For some reason it keeps failing at this particular line (which I've also highlighted red in the macro below):

Please Login or Register  to view this content.

I've used similar code in other macros (in the same workbook even) and can't seem to get my head around why it keeps failing here...I'm sure it's something simple and I'm overlooking it because I've been looking at this macro for too long. If someone is able to help out I'd be greatly appreciative.

My macro is as follows:

Please Login or Register  to view this content.

Originally Posted by TMS

Seems confusing, at least to me, that namesheet2 relates to wb and namesheet relates to wb2. You should be consistent in your naming. Whatever, try without the wb. and the wb2.

Regards, TMS

Thanks for the reply Trevor, apologies, I usually do keep my naming consistent...it just got a little out of whack while I was trying different things.

If I run it without the wb. and the wb2. then I get Run-time error '1004': Method 'Range of object'_Worksheet' failed, which makes sense given the two ranges are in different workbooks so it can't find them if it's looking for them both in the same workbook...if I'm understanding this correctly? Yet if I reference the workbooks as in my original posted code (i.e. running it with the wb and wb2) I get Run-time error '438': Object doesn't support this property or method.

Please see updated code below with consistent naming:

Please Login or Register  to view this content.

Thanks so much mikerickson, that worked a treat. I can't believe it was that simple!