Macro to extract URL's from a hyperlink, any thoughts?

[Guest]

Does anyone know of a macro that will extract a URL out of a hyperlink so that I can paste the URL into a cell? I have thousands of hyperlinks, and I need the URL that is associated with the URL. Thank you...

Taylor in Tennessee

 

[Juan Pablo González]

Sure...(This I assume is from a "real" Hyperlink, not from one resulting of the HYPERLINK formula)

I got this from the inmediate window:

?ActiveCell.Hyperlinks(1).Address
http://www.mrexcel.com/

 

[Guest]

I am sorry, I did not understand that answer.

Taylor

 

[Aladin Akyurek]

See also:

http://mrexcel.com/board/viewtopic.php?topic=200&forum=2