I think its the sheet names. If they dont exist in the referenced
workbook then the interpretor will break on that error. I think simpler
naming will suffice.

ikr wrote:
"SamuelT" wrote in
message ...
My remedy would be that you better describe what "Something wrong
here
though" means.

Better desciption = Run-time error '9':
Subscript out of range

That probably indicates a sheet name you've specified in your code that
doesn't exist. Have you double-checked the sheet names, including for
rogue/trailing/leading (multiple-)spaces?