How to email 1 sheet in a workbook?

  • Thread starter Thread starter Hosh
  • Start date Start date
H

Hosh

I have a workbook with an individual sheet for every month in the year. At
the end of each month, that month's sheet must be emailed corporate wide.
Presently, I copy that month's sheet to a new workbook and send that
workbook out as an email.

Isn't there a way that I can just send one sheet out without creating a new
workbook that only has 1 month in it?

Thanks.
 
Back
Top