excel macro hyperlinks

  djbenny 13:44 11 Nov 2010
Locked

hello

i need a simple macro that converts plain text links into hyperlinks that are clickable from a selection that i highlight but will be column A as i have loads of sheets with plain hyperlinks and need to go through them quickly

  VoG II 14:03 11 Nov 2010

Try


Sub Hyper()
Dim c As Range
For Each c In Selection
c.Hyperlinks.Add Anchor:=c, Address:="http://" & c.Value & "/"
Next c
End Sub

  djbenny 14:20 11 Nov 2010

does itstop once it has done the job as i just click on the column header A and it selects the whole column and has gone to not responding, also how can i get it to work with all excel files?

  VoG II 14:26 11 Nov 2010

Try selecting a smallish range, not the whole column.

  djbenny 11:26 12 Nov 2010

works thanks :)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?