Ok, Im trying to copy some data from closed workbook to the current active woorkbook. I get to the point where code is reading data from closed workbook and can paste it into sheet2 in that workbook. This is my new code:
But once I change that part of code:
into that code:
It stop working issuing error: "subscription is out of range".
File general.xlsx is an empty file which is closed as well.
When I change code into:
It then issue an error: "1004 cannot change part of merged cell".
File "Your Idea.xlsm" is the file from which I running this script.
Any help with this problem?
Bookmarks