Pasting URL from Browser Address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vetbabe - 18 Mar 2004 19:37 GMT

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.

Reply to this Message

Bill Manville - 19 Mar 2004 00:57 GMT

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

Reply to this Message