I have ten workbooks and I will be running the code below. Each workbook is assigned (a, b, c, d, e, F, g, h, i, j, k, l).
How do I shorten this and make it run through this code without repeating the code like below?
Please Login or Register to view this content.
Would it be something like?
Please Login or Register to view this content.
Hello taylorsm,
You are close. The array values must be strings as they are workbook names.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Great. Just to be clear, so This
just becomesPlease Login or Register to view this content.
Please Login or Register to view this content.
Edit*
I guess this is why we normally paste the whole code, but when I declare a workbook I do "Set j = Workbooks("John - October 2018.xlsm")" would I still need to add the "Workbooks(V)" or could I just do "V"?
Last edited by taylorsm; 10-03-2018 at 05:42 PM.
Hello taylorsm,
If you have assigned zRng to the range to be copied then your code will work.
Another approach would be to use the Workbooks collection instead of an array...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks