Under the 'Paste you will see the array code I have made comments. After that is what I have to use because I can't get the array to work. I've tried a couple different variations. The other Array codes (remove objects and close workbooks) work, so I figure it isn't the array itself but I don't know.
Please Login or Register to view this content.
Perhaps:
Why did you stick On Error Resume Next in there? It's just going to mask whatever was wrong.Please Login or Register to view this content.
Rory
Because if i don't I will get an error hereIt is set to say, if the workbook is already open here, if it isn't go here and open. Is there a better way of doing it? I've had it this way for sometime and I'm betting that I received help from this forum when I set it up for it because until recently that would have been outside my skill level, but if there is another way to do it then i'm 100% open to an easier way. love to learn itPlease Login or Register to view this content.
I meant the one before ZRng.Copy actually. You should only leave an OERN line in effect for the minimum amount of code necessary.
Oh probably because i'm an idiot and its junk code. I will end it after opening the files and remove that.
Given that you are doing the same thing repeatedly, I'd probably refactor that into a separate function and call it for each workbook. Then you can put the OERN into just that function, rather than the main code.
Yes! I literally thought that while I was posting. not sure how to make that its own thing and then call to it though. That would save a lot of work because each month I have to update about six macros that have this exact language.
Perhab like this
Please Login or Register to view this content.
Last edited by daboho; 10-17-2018 at 03:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks