Hi,
I was wonding if you could help me out with some code efficiency. I have two workbooks - One I cycle through to find an existing result, the second I paste in the correct place. However I can't get it to work without using "DestWB.Activate" and "SrcWB.activate" to copy/paste once the result is found. This cycling between workbooks is the slowest bit of the code. Is there a more efficient way?
thanks for any assistancePlease Login or Register to view this content.
Bookmarks