Hello All,
I have the below function I am trying to get working.
The code completes fine, but no data is actually being pasted to the destination workbook. I have ensured there is data present in the range by doing a Message Box check of some values.
Please Login or Register to view this content.
Is there something wrong with what I am doing? Please help!
Why are you opening the workbook in a separate instance of Excel?
Entia non sunt multiplicanda sine necessitate
It is actually between two workbooks I want to copy and paste between. One has the sheet "Trans Details - Current Month", and one is the workbook currently open where I am running the function from.
I get that. My question is, why not open the workbook in the same instance of Excel as ThisWorkbook is open in?
I'm not quite sure how I would do that. But would that be the difference as why the data is not pasting?Originally Posted by shg
Untested:
Please Login or Register to view this content.
Last edited by shg; 07-29-2013 at 11:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks