extract XL cell's hyperlink
extract XL cell's hyperlink
(OP)
Looking for a way to extract the URL from an XL cell (cell is typically displaying a link as an underlined name).
Thanks.
Thanks.
BigInch
-born in the trenches.
http://virtualpipeline.spaces.msn.com





RE: extract XL cell's hyperlink
Something like this:
For Each h In Worksheets(1).Hyperlinks
test = h.Address
Next
TTFN
RE: extract XL cell's hyperlink
BigInch
-born in the trenches.
http://virtualpipeline.spaces.msn.com
RE: extract XL cell's hyperlink
CODE
GetHyperlink = R.Hyperlinks(1).Address
End Function
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.