I have the following macro that works fine if the destination workbook is closed, how can I modify it because the destination workbook as it will always be open and if it is I currently I get the message workbook already open.
I have tried to alter this linePlease Login or Register to view this content.
toPlease Login or Register to view this content.
But that gives me a subscript errorPlease Login or Register to view this content.
Thanks for any assistance
Bookmarks