Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple C&P Q (internet to Excel)
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple C&P Q (internet to Excel)
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 On Wed, 3 Sep 2008 13:23:02 -0700, MaryS wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Data from the Internet to Excel | Excel Discussion (Misc queries) | |||
excel and internet. | Excel Discussion (Misc queries) | |||
Download from the Internet into Excel | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Excel & internet | Excel Discussion (Misc queries) |