Hi,
I'm trying to copy cell values from a source sheet to another worksheet, therefore I set the activeworkbook as wb1 and open the second workbook as wb2.
My code fails on the wb2.ws2 part, what going wrong?
Please Login or Register to view this content.
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thanks!Originally Posted by sintek
Please Login or Register to view this content.
So it was purely caused by the incorrect Dim?
Your variable declarations were incorrect ...
this means ws1 is a variant and ws2 is a worksheetPlease Login or Register to view this content.
but also...You were referencing the sheet in wb2 incorrectly
the red part must be left outPlease Login or Register to view this content.
Last edited by sintek; 04-30-2019 at 06:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks