Extract a hyperlink from cell value

[mabc]

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

[Anne Troy]

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

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"mabc" <mabc@discussions.microsoft.com> wrote in message
news:91BF87AF-27CC-4AA8-9B87-0C0696209A0E@microsoft.com...
> I need how to get the hyperlink from a cell with VBA

[mabc]

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