Hi Forum experts, first post!
Trying to get 3 specified sheets from one work book copied over to another workbook.
Set up an array and loop and it runs through the first loop but gets stuck with a subscript out of range error at the Set in the second loop.
Any idea what I'm doing wrong?
Please Login or Register to view this content.
I think this should do what you want … if that is to copy three sheets to the Target.xlsm workbook.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
No need for a loop, this will copy 'source1', 'source2' and 'source3' from the active workbook to 'target.xlsm'.
Please Login or Register to view this content.
If posting code please use code tags, see here.
used a variation of Norie's code, thanks to both!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks