E
expect_ed
If I copy an HTML page from IE and paste it into Excel (2003) the hyperlinks
from the page remain. But if I look at the cell contents/formula there is no
Hyperlink function shown. I can get the URL with a HyperlinkAddress function
as descibed here:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Function HyperlinkAddress(cell) As String
If cell.Hyperlinks.Count > 0 Then _
HyperlinkAddress = cell.Hyperlinks(1).Address
End Function
MY QUESTION: Is there a way for me to complete a cell so that the effect is
the same? i.e. the Hyperlink statement does not appear in the cell but
clicking in the cell still activates the link.
TIA
ed
from the page remain. But if I look at the cell contents/formula there is no
Hyperlink function shown. I can get the URL with a HyperlinkAddress function
as descibed here:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Function HyperlinkAddress(cell) As String
If cell.Hyperlinks.Count > 0 Then _
HyperlinkAddress = cell.Hyperlinks(1).Address
End Function
MY QUESTION: Is there a way for me to complete a cell so that the effect is
the same? i.e. the Hyperlink statement does not appear in the cell but
clicking in the cell still activates the link.
TIA
ed