Pasting URL from Browser Address

Window into Excel results in text rather than a hyperlink. I've been
searching for an answer all morning, and I'm sure it's something that I'm
being duh about. Any help is greatly appreciated.

Vetbabe wrote:
Window into Excel results in text rather than a hyperlink. I've been
searching for an answer all morning, and I'm sure it's something that I'm
being duh about. Any help is greatly appreciated.


That's how it goes.
You could turn the text into a hyperlink after the paste by running this
macro, selecting as many cells as you like that contain web addresses that
are not hyperlinks...

Sub MakeHyperlinks()
Dim C As Range
For Each C In Selection.Cells
If C.Hyperlinks.Count = 0 And Not IsEmpty(C) Then
C.Hyperlinks.Add C, C.Value
End If
Next
End Sub

MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup