Hello,
I am trying to copy some values from a workbook that is not open and paste them into the active workbook that contains the macro. Though it sounds relatively easy, I cannot do it.
The problem seems to be when pasting the values, at the last line of my code. I keep receiving the following message : "Run time error 438 Object doesn't support this property or method".
The code that I have written is the following:
Do I need to change the entire structure or could I do sth simpler to make that work?
Thanks and regards,
Ilias
Bookmarks