Hyper lInks

[vallury]

Hello All!

I do have one excel spreadsheet with text like www.yahoo.com
www.excelforum.com and so on.

Is there a way that I select all the cells and make them hyperlinks s
that if the user click on www.yahoo.com it should go to yahoo.co
site.

Appreciate if you could help me ou

 

[Guest]

Excel 2003:
Select the cell
Choose Insert, Hyperlink
Click "Place in the document"
- If there is a range with webpages like A1:A10 -
- Type this range A1:A10 in the textbox "Text to display" -
Click OK

Regards,

Claude Bluebirdy

 

[Gord Dibben]

vallury

To change a bunch at one time you will use a 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 Excel MVP