<div>
I believe this is what you are looking for.<br />
<a href="http://www.rondebruin.nl/mail/folder1/mail4.htm" rel="ugc">http://www.rondebruin.nl/mail/folder1/mail4.htm</a><br />
Saurabh... <br />

</div>


I believe this is what you are looking for.
http://www.rondebruin.nl/mail/folder1/mail4.htm [http://www.rondebruin.nl/mail/folder1/mail4.htm]
Saurabh...


<div>
Thanks Saurabh,<br />
<br />
This was very helpful indeed! but the email is hardcoded:I do not want that:I wnat the user to be able to specify the email without having to change,is there a way to do it?<br />
<br />
Thanks again
</div>


Thanks Saurabh,

This was very helpful indeed! but the email is hardcoded:I do not want that:I wnat the user to be able to specify the email without having to change,is there a way to do it?

Thanks again

<div>
When you mean specify, You meant to say email id or the body..?
</div>


When you mean specify, You meant to say email id or the body..?

<div>
In the link i give to you, if you refer to this line of the code...<br />
.SendMail &quot;ron@debruin.nl&quot;, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;This is the Subject line&quot;<br />
<br />
This is where you need to mentioned the email address.<br />
Saurabh... <br />

</div>


In the link i give to you, if you refer to this line of the code...
.SendMail "ron@debruin.nl", _
                  "This is the Subject line"

This is where you need to mentioned the email address.
Saurabh...


<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I have a question: I am new to VBA and I am interested in the follows:<br />
<br />
I have a workbook called &quot;work.xls&quot; and a worksheet &quot;vacation&quot;.I want to write a macro that allows me to do the following:<br />
<br />
when I select a range in the worksheet &quot;vacation&quot; : it must generate a new worksheet with my selected range(and this new worksheet I want to send as a email)<br />
<br />
<br />
Thnaks someone please guide me on this<br />
<br />
Regards<br />
<br />
Arun
</div>
</div>


Hi:

I have a question: I am new to VBA and I am interested in the follows:

I have a workbook called "work.xls" and a worksheet "vacation".I want to write a macro that allows me to do the following:

when I select a range in the worksheet "vacation" : it must generate a new worksheet with my selected range(and this new worksheet I want to send as a email)


Thnaks someone please guide me on this

Regards

Arun

copy user selected range into a new worksheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.