How do you select and e-mail part of a work sheet, each
time i try i get the whole sheets as part of the e-mail
I don't think it can readily be done programmatically. However, if you
use an e-mail client which supports messages in HTML (I use Outlook), you
can copy/paste a part of your worksheet into the body of the message.
To create an attachment in VBA, you would have to construct a temporary
workbook with only the content you want, and e-mal that.
