Advanced Search

Convert Excel plain text links to hyperlinks

/ Published in: Visual Basic
Save to your folder(s)
Save the following code as a macro and then apply it to the fields you want to convert

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.