Extract a hyperlink from cell value
 

I need how to get the hyperlink from a cell with VBA

Extract a hyperlink from cell value
 

http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"mabc" wrote in message
...
I need how to get the hyperlink from a cell with VBA

Extract a hyperlink from cell value
 

I already find the way:

For example, if the cell "B3" has a hyperlink, this code extract the link
value:

Range("B3").Select
MsgBox (ActiveCell.Hyperlinks(1).Address)


"mabc" wrote:

I need how to get the hyperlink from a cell with VBA