Copy Multiple Sheets produces RunTime Error

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.

Hey moxman,

try this

Formula:

Please Login or Register  to view this content.

I hope that helps.

Thanks
Lex

Hi lexusap!

I have tried that code before. It used to be from the "record macro" script.

It worked a couple times before but it is erratic and produces the runtime error '-2147417848 (800010108)

Is there a way to copy multiple sheets without producing the error and crashing my excel.

Please Login or Register  to view this content.

You have the active workbook SET twice,wb and NewWb.
If the sheet arrays are from the active sheet, perhaps you should include a reference to the active workbook

Please Login or Register  to view this content.