+ Reply to Thread
Results 1 to 3 of 3

Convert entire columns of text email addresses to hyperlinks

  1. #1
    TSA
    Guest

    Convert entire columns of text email addresses to hyperlinks

    How do I convert an entire column of text only email addresses
    to hyperlinks pointing to the same email address?

    Any help greatly appreciated



  2. #2
    Ron de Bruin
    Guest

    Re: Convert entire columns of text email addresses to hyperlinks

    Try this one for Column B in the activesheet

    Sub test()
    For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
    If myCell.Value Like "*@*" Then
    ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
    Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value
    End If
    Next
    End Sub


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "TSA" <tsa68@[removethisfirst]verizon.net> wrote in message news:[email protected]...
    > How do I convert an entire column of text only email addresses
    > to hyperlinks pointing to the same email address?
    >
    > Any help greatly appreciated
    >
    >




  3. #3
    TSA
    Guest

    Re: Convert entire columns of text email addresses to hyperlinks

    Works great!........Thanks!


    "Ron de Bruin" <[email protected]> wrote in message
    news:[email protected]...
    > Try this one for Column B in the activesheet
    >
    > Sub test()
    > For Each myCell In

    Columns("B").Cells.SpecialCells(xlCellTypeConstants)
    > If myCell.Value Like "*@*" Then
    > ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
    > Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value
    > End If
    > Next
    > End Sub
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    >
    > "TSA" <tsa68@[removethisfirst]verizon.net> wrote in message

    news:[email protected]...
    > > How do I convert an entire column of text only email addresses
    > > to hyperlinks pointing to the same email address?
    > >
    > > Any help greatly appreciated
    > >
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1