What does this mean?

I figured that a cell would contain a single email address. So each cell would
require its own hyperlink.



Satish wrote:

Thanks for the reply, but can you help in writing a macro where i want
to do it for a range.

Regards
Satish

On Dec 18, 8:04 pm, Dave Peterson wrote:
If your data is in A1:A10 (say), you could add some formulas in B1:B10:

Put this in B1:
=hyperlink("mailto:" & a1,"Click to sendemail")
and drag down to B10

Satish wrote:

Hi
Can anyone help me in writing amacroon how tocreateemaillink
for theemailaddressesin aRangeorSelection.As i am new to excel i
am manually selecting each cell which is havingemailaddress , 'Press
F2' and then "Press ENTER".I want to automate the process and save the
precious time.

--

Dave Peterson

--

Dave Peterson