Copying a sheet is easy

sheet1.copy

or

Sheets("Sheet1").copy

In order to e-mail it through code is a little trickier. I am assuming MS
Outlook. You should check out http://www.rondebruin.nl/

HTH

"mac" wrote:

Hello,
I am hoping someone can help me with a macro. I need to copy a specific
worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help
will be greatly appreciated.
--
thank you mac