Results 1 to 8 of 8

Thread: excel hyperlink

  1. #1
    eve rybody
    Guest

    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.
    Ta
    Brian

  2. #2
    godfather
    Guest

    Default Re: excel hyperlink

    Explain the "value" of the hyperlink?

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

  3. #3
    Mark Veldhuizen
    Guest

    Default Re: excel hyperlink

    Probably list the actual URL/ADDRESS that is hyperlinked?

    I don't know how.

  4. #4
    godfather
    Guest

    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
    Barnabas
    Guest

    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

    =Barnabas(A1)

    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.

    B.

  6. #6
    godfather
    Guest

    Default Re: excel hyperlink

    That works.

    Filed for reference, thanks!

  7. #7
    eve rybody
    Guest

    Default Re: excel hyperlink

    Worked a treat. Thank you very much
    ttfn brian

  8. #8
    Barnabas
    Guest

    Default Re: excel hyperlink

    Glad to be of service.

    B.

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
  •