I need a macro that will email the same range (A2:H46) from every worksheet and email that worksheet to the individual email in cell A60.
I’ve read over Ron de Bruin’s website to find a solution for this problem (and every source I can find). I’ve found solutions for emailing every worksheet and a solution for emailing a range, but not combining these two events. I can't seem to piece these two together.

Mail every worksheet with address in A1
http://www.rondebruin.nl/mail/folder2/mail5.htm

Mail Range or Selection
http://www.rondebruin.nl/mail/folder2/mail4.htm

Thank you!