Hyperlink information in Excel

[BillMcKay]

How can I access hyperlink information stored in a cell of an Excel spreadsheet

[Chip Pearson]

Something like

Debug.Print Range("A1").Hyperlinks(1).Address
Debug.Print Range("A1").Hyperlinks(1).TextToDisplay


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"BillMcKay" <[email protected]> wrote in
message
news:[email protected]...
> How can I access hyperlink information stored in a cell of an
> Excel spreadsheet