View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bobbabuoy
 
Posts: n/a
Default Pulling Embedded LInk Out of Cell


I have a list of sites (ex-"Running Site") 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: http://www.excelforum.com/member.php...o&userid=33491
View this thread: http://www.excelforum.com/showthread...hreadid=532907