Posted By

kidmizere on 03/07/12


Tagged

excel hyperlinks


Versions (?)

Convert Excel plain text links to hyperlinks


 / Published in: Visual Basic
 

URL: http://www.jerryleventer.com/excel-tutorial-how-to-convert-plain-text-links-into-hyperlinks/

Save the following code as a macro and then apply it to the fields you want to convert

  1. Public Sub Convert_To_Hyperlinks()
  2. Dim Cell As Range
  3. For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
  4. If Cell <> "" Then
  5. ActiveSheet.Hyperlinks.Add Cell, Cell.Value
  6. End If
  7. Next
  8. End Sub

Report this snippet  

You need to login to post a comment.