software

I have a list of sites (ex-quot;Running Sitequot;) in an excel column that are
formatted as links (ie: a browser with a link opens when you click on
the cell). I want to write a macro that will pull the links out of the
cell and write them to a text file or an adjacent column. How can I do
that? I basically just need the line of code that will identify the
link that is embedded in the cell.

Thanks~--
bobbabuoy
------------------------------------------------------------------------
bobbabuoy's Profile: www.excelforum.com/member.php...oamp;userid=33491
View this thread: www.excelforum.com/showthread...hreadid=532907If A1 contains a hyperlink then

=hyp2(A1) will display the link

Enter this tiny UDF:

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function

--
Gary's Studentquot;bobbabuoyquot; wrote:

gt;
gt; I have a list of sites (ex-quot;Running Sitequot;) in an excel column that are
gt; formatted as links (ie: a browser with a link opens when you click on
gt; the cell). I want to write a macro that will pull the links out of the
gt; cell and write them to a text file or an adjacent column. How can I do
gt; that? I basically just need the line of code that will identify the
gt; link that is embedded in the cell.
gt;
gt; Thanks~
gt;
gt;
gt; --
gt; bobbabuoy
gt; ------------------------------------------------------------------------
gt; bobbabuoy's Profile: www.excelforum.com/member.php...oamp;userid=33491
gt; View this thread: www.excelforum.com/showthread...hreadid=532907
gt;
gt;

activecell.Hyperlinks(1).Addressquot;bobbabuoyquot; wrote:

gt;
gt; I have a list of sites (ex-quot;Running Sitequot;) in an excel column that are
gt; formatted as links (ie: a browser with a link opens when you click on
gt; the cell). I want to write a macro that will pull the links out of the
gt; cell and write them to a text file or an adjacent column. How can I do
gt; that? I basically just need the line of code that will identify the
gt; link that is embedded in the cell.
gt;
gt; Thanks~
gt;
gt;
gt; --
gt; bobbabuoy
gt; ------------------------------------------------------------------------
gt; bobbabuoy's Profile: www.excelforum.com/member.php...oamp;userid=33491
gt; View this thread: www.excelforum.com/showthread...hreadid=532907
gt;
gt;