I have a code that is almost exactly like this, except I am copying 8 different ranges from different workbooks into one, while this one is taking one range from one workbook into 8 different ones. This is a shorten code, but same issue. It will highlight the range in 'z' but not paste anything.
Please Login or Register to view this content.
Hi,
You're copying from z to a and then closing a without saving. Did you mean to copy the other way?
Don
Please remember to mark your thread 'Solved' when appropriate.
Sorry, right now 'a isn't closing. It will, but i'll save it. right now, everything is left open.
I figured out that it is because the workbooks were already open. Can I adjust to run either way?
You might do something like this
Please Login or Register to view this content.
OK. Thanks.
If I leave Z open, it leaves the range selected with that copy border buzzing around the range. I tried to just select A1 to stop that but it errored. How do I?
should remove the dancing antsPlease Login or Register to view this content.
Thanks for the help!
Hey, so I am getting subscript out of range when I try
Please Login or Register to view this content.
You don't include the path when accessing the Workbooks collection, and you need an error handle- review the differences between my code and yours.
oh jesus christ! long day
but i'm still having the issue and I think i've straightened my last issue out and i'm reflecting yours.
Please Login or Register to view this content.
I didn't have the On Error part. I was avoid that because I wanted to test and see any errors, which of course cause it to never get passed step one lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks