Hi,
Excel's formulas return values, they will not return the associated
hyperlink or comment or error checking message.
You might be able to right a custom VBA function that will do this for you.
Here is a sample, that doesn't quite do what you want but it might start you
on the way
Function RETURNHYPERLINK(Rng As Range) As String
If Rng.Hyperlinks.Count> 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).Address
If Len(RETURNHYPERLINK) = 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).SubAddress
End If
End If
End Function
This function, entered as =ReturnHyperlink(A1) would return the hyperlink
of cell A1.
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"OX_Gambit" <OXGambit[ at ]discussions.microsoft.com> wrote in message
news:4DD0592B-9E76-4CF2-8CA8-D66BB7C97657[ at ]microsoft.com...
[Quoted Text] > I have one sheet that has a list that contains some text that has
> hyperlinks
> and then I use lookup ona different sheet, but when the text is displayed
> onthe second sheet the hyperlink is not there. Is there a way of keeping
> the
> hyperlink on the second sheet. The hyperlink uses tags.
|