Hi, I've been working on this code for quite some time now.
I have seen it work most of the time but its very glitchy and produces a runtime error then closes all my excel windows.
What I wanted to accomplish is to copy multiple sheets into a new workbook then save the file or send an email.
The error starts at the line where i've declared the sheets (array) to be copied.
Please Login or Register to view this content.
Bookmarks