Microsoft Excel guru (Please help)

[staffjam]

Hi,

I'm trying to figure out how to put automatic hyperlinks in some web addresses - so they automatically click through to the site. e.g.:
www.robin.com
www.happy.net
www.bigboy.org

I've been trying to figure it out and i have 1000 sites to check out and really don't want to have to type them all in. I've tried inserting a hyperlink, but it doesn't come through as a live link.
Any help would be greatly appreciated.

Thanks

 

[Corey]

Are you referring to URL forwarding at the Domain Name Registrar?

Not sure exactly what you are asking, if you supply more information that would be good.

Cheers
Corey

 

[nasaboy007]

i think what he wants is a way to visit sites from a url in an excel file by just clicking...

one trick would be to take an empty column, and use the following:

=HYPERLINK(A1,A1)

where A1 is the cell that has the URL you want.

then just copy/paste that down (it should offer to fill in all of them if you just keep going down). it shoudl also automatically change A1 to A2, A3, A4, etc as you go down. then, you should be able to click those hyperlinks.


does that help?

 

[Kate]

I assume you have a column of URLs as non-clickable text correct ?
To convert the text to hyperlinks you could run a macro like this, assuming your range is "a1:a40"

Dim r As Integer, str As String

For r = 1 To Sheets("Sheet1").Range("a1:a40").Rows.Count ' scan rows
    str = Sheets("Sheet1").Cells(r, 1).Value ' read cell value
    str = "http://" & str ' add leading http://
    Sheets("Sheet1").Cells(r, 1).Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=str, TextToDisplay:=str ' convert to hyperlink
Next r

 

[weblord]

excel's default is treat all prefixed with "www" and/or "http://" as automatic hyperlinks so they're all clickable.

 

[staffjam]

Sorry for coming back late- been on holiday.

The list i'm talking about has been merged - so no hyperlinks were created.
Nasaboy - i tried what you suggested but didn't have any joy.
Sdsinc- yes i have a column of url's as non clickable text - sadly i haven't got a clue how to apply the macro you have written.

 

[Kate]

Sdsinc- yes i have a column of url's as non clickable text - sadly i haven't got a clue how to apply the macro you have written.

Open Excel, then use menu Tools -> Macro -> Record new macro. Stop recording.
Again go to menu Tools -> Macro -> Macros, select the macro you've just recorded and click Edit. You will see a new window with code like this:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 8/12/2008 by ...
'

'
End Sub

Paste the code between Sub & End Sub.
You may have to change the range (here a1:a40) to fit your needs.

Return to Excel. Use menu Tools -> Macro -> Macros, and click Run to execute the code. This should convert the URLs to clickable links.

 

[staffjam]

Thanks - i've tried it and still can't get it to work