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):
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:
Bookmarks