View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Murali Srinivasan Murali Srinivasan is offline
external usenet poster
 
Posts: 1
Default Decode from URL of hyperlink

I am copying some text from the browser which are actually
hyperlinks (text is hyperlinked).

When I paste it in Excel, the text is hyperlink and it is
linking to the web page, I want to go.

My requirement is to store the text & underlying hyperlink
URL separately in 2 columns. Is there a way to get the
hyperlink property (through macro or by any function)

Thanks in advance
Murali