Results 1 to 4 of 4
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Hyperlinks in Excel 2002 (2002)

    I have a column of web addresses, next to a column of descriptions of the sites. I want to convert the descriptions into links that open the web pages.

    How do I do it?

    When I had Excel 97, every time I'd type a web address, Excel would turn it into a link; I found a workaround and it made my life much better.

    Now I type a web address, and I can't figure how to make it turn into a link. I guess what goes around, comes around. Or something like that. Sheesh.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks in Excel 2002 (2002)

    This macro creates a hyperlink in column C, where column A contains the addresses and column B their descriptions:

    Sub ChangetoHyperlinks()
    Dim rCell As Range
    For Each rCell In ActiveSheet.UsedRange.Columns(1).Cells
    ActiveSheet.Hyperlinks.Add Anchor:=rCell.Offset(, 2), _
    Address:=rCell.Value, _
    TextToDisplay:=rCell.Offset(, 1).Value
    Next
    End Sub
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Hyperlinks in Excel 2002 (2002)

    Thanks. I'll try it.

    Is there a way to do it manually for just a few rows?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks in Excel 2002 (2002)

    You could use the =hyperlink function, but in that case you would have to keep the original cells and refer to those using the HYPERLINK function:

    =HYPERLINK(A1,B1)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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