Excel email macro failing on sheet array

Hello, I am trying to adapt a macro from Ron DeBruins website to email an array of sheets but it is failing when it is trying to determine which sheets to send. The error message says "Run-time error '9': Subscript out of range" A second question I have is how do I change this to only email the visible sheets?

This is the line it is failing on:

Please Login or Register  to view this content.

The whole macro:

Please Login or Register  to view this content.

Thanks for any guidance you can give!

Clayton Grove

Leith, thank you for the assistance! I was hoping you would stumble into my thread! I ran your macro but it failed with an error that says "Compile Error: Invalid qualifier" on the section below:

Please Login or Register  to view this content.

On this line:

Please Login or Register  to view this content.

Any ideas what is causing this?

Thanks again!

Clayton Grove

No worries! I changed that line of code and now is give me an error that says "method 'copy'of object 'Sheets' failed" on that same line.

Please Login or Register  to view this content.