Sorry

I should have explained that select all the pertinent cells first then run
the macro.


Gord

On Thu, 06 Aug 2009 12:38:34 -0700, Christopher Glenn wrote:

Thanks Gord, but I think I'll go with the newbie method. The F2+Enter
also automatically moves to the next cell down in the same row, so
it's quick work to do them.


On Thu, 06 Aug 2009 11:15:59 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

On Thu, 06 Aug 2009 08:44:58 -0700, Christopher Glenn wrote:

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.