More info please.
You want to email one sheet out a workbook?
Copy that sheet to a new workbook and send that.
See Ron de Bruin's site for sending mail from Excel.
http://www.rondebruin.nl/sendmail.htm
Ron's SendMail add-in is quite handy.
Gord Dibben MS Excel MVP
On Fri, 1 Feb 2008 10:44:01 -0800, Sharon
wrote: