Results 1 to 8 of 8

Thread: excel hyperlink

  1. #1
    eve rybody

    Default excel hyperlink

    I have a list of names in col A (Excel) The name such as Jim Bean has a Hyperlink attached.
    I want to show the value of the hyperlink in the B column.
    Is there any formula or macro that I can use to do this.

  2. #2

    Default Re: excel hyperlink

    Explain the "value" of the hyperlink?

    Can't quite grasp what you are trying to do?

  3. #3
    Mark Veldhuizen

    Default Re: excel hyperlink

    Probably list the actual URL/ADDRESS that is hyperlinked?

    I don't know how.

  4. #4

    Default Re: excel hyperlink

    Ah--I see now.

    Probably the hyperlink is an email address, and they want that shown in another cell.

    No available function to do that as I see it, but a VB expert may know on a method.

  5. #5

    Default Re: excel hyperlink

    This will show the path that the hyperlink is pointing to.

    Function Barnabas(myRange As Range) As String

    Dim String1 As String
    Dim String2 As String

    If myRange.Hyperlinks.Count = 0 Then
    Exit Function
    End If

    String1 = myRange.Hyperlinks(1).Address
    String2 = myRange.Hyperlinks(1).SubAddress

    If String2 <> "" Then
    String1 = "[" & String1 & "]" & String2
    End If

    Barnabas = String1

    End Function

    Just go to tools, macro, visual basic editor, make a new module and then copy and paste the code into that module and save. Now in your worksheet simply enter the formula


    or whatever the cell reference happens to be and the path of the hyperlink will be displayed.
    Hope this is what you were after as it wasn't terribly clear. If not post again and I'll go from there.


  6. #6

    Default Re: excel hyperlink

    That works.

    Filed for reference, thanks!

  7. #7
    eve rybody

    Default Re: excel hyperlink

    Worked a treat. Thank you very much
    ttfn brian

  8. #8

    Default Re: excel hyperlink

    Glad to be of service.


Similar Threads

  1. Replies: 1
    Last Post: 28-09-2008, 11:35 PM
  2. Hyperlink values in Excel
    By MChanguion in forum PC World Chat
    Replies: 3
    Last Post: 22-05-2007, 11:32 AM
  3. Excel Hyperlink problem
    By brian-zl1thf in forum PressF1
    Replies: 3
    Last Post: 09-03-2005, 07:13 PM
  4. hyperlink question
    By chasbenest in forum PressF1
    Replies: 1
    Last Post: 08-03-2005, 07:53 AM
  5. hyperlink help plz!
    By in forum PressF1
    Replies: 2
    Last Post: 07-03-2001, 07:57 PM

Posting Permissions

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