Simple C&P Q (internet to Excel)

M

MaryS

There is a list of school on the internet, each a hyperlink to the school
home pg. I want to copy that into column A (Excel 2003) so I can add other
data as I research each school. But when I C&P the list of school names
(hyperlinks), the names show up in the worksheet, but the hyperlinks are
lost. It works OK in Word - but not in Excel 2003.
What am I doing wrong?
Thanks,
Mary
 
G

Gord Dibben

You're doing nothing wrong

Excel won't do what you want without some help.

Select the range and run this macro.

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
 
Top