Mike Barram
BlogTagsProjectsAbout
Blog
Tags
Projects
About
Published on
Friday, 21 September 2012

Convert URLs to hyperlinks in Excel using VBA

Authors
  • avatar
    Name
    Mike Barram
    Twitter
Public Sub Convert_To_Hyperlinks()
    Dim Cell As Range
    For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
        If Cell <> "" Then
            ActiveSheet.Hyperlinks.Add Cell, Cell.Value
        End If
    Next
End Sub
Discuss on Twitter • View on GitHub

Tags

uom

Previous Article

Linked servers in SQL Server

Next Article

HTML emails
← Back to the blog
githublinkedin
Mike Barram
•
© 2022
•
Mike Barram
Tailwind Nextjs Theme