Hi All,
I am having an issue and keep getting the same error on all the codes I come up with for this problem.
Basically I am trying to write a macro that will copy all the sheets from a named workbook and transfer them to the workbook I am running the macro in, I have tried using ActiveWorkbook, ThisWorkbook and defining and naming the workbook I am currently running the macro in. I keep getting
Run-time error '9'
Subscript out of range
Here is my current code.
If anyone could amend/suggest another code to do what I am looking for that would be great guys!
Bookmarks