Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    May 2007
    Posts
    4

    Default Hyperlink values in Excel

    Hi Everyone

    Here is a teaser hopefully somebody can help me solve:

    I need to see the value of a hyperlink in Excel Pro 2003 ie the reference to which the hyperlink points - this value needs to be inserted in an adjacent cell.

    I saw http://forums.pcworld.co.nz/showthread.php?t=40508 on this board from a few years ago - it is exactly what I need, but doesn't seem to work for me - I get a #Name? error in Excel. I have double checked the module name, but something is still missing!

    Thanks in advance for your help on this one.

    Marc

  2. #2
    Modulator Greg's Avatar
    Join Date
    Dec 2004
    Location
    Napier
    Posts
    9,115

    Default Re: Hyperlink values in Excel

    Perhaps check that your Visual Basic editor is enabled? Go to Help, type in Visual Basic and you should see some options. Eg...

    "On the Tools menu, point to Macro, and then click Visual Basic Editor.
    On the Help menu, click Microsoft Visual Basic Help."
    Bugger the cancer. I'm suffering from terminal inertia.

  3. #3

    Default Re: Hyperlink values in Excel

    In the example give, the formula "=Barnabas(A1)" is for a hyperlink in cell A1.

    If your hyperlink is in another cell eg D5 - then in any cell other than D5 enter =Barnabas(D5) and it will work.

  4. #4
    Junior Member
    Join Date
    May 2007
    Posts
    4

    Default Re: Hyperlink values in Excel

    Thanks for the help ....

    your answers prompted me to look at my security settings - this was on high - as soon as I turned it to low, it worked.

    Thank you very much for your replys.

    Marc

Similar Threads

  1. Replies: 1
    Last Post: 28-09-2008, 11:35 PM
  2. Fixing Excel Date values
    By Tony in forum PressF1
    Replies: 10
    Last Post: 22-06-2005, 05:34 PM
  3. excel hyperlink
    By eve rybody in forum PressF1
    Replies: 7
    Last Post: 10-12-2003, 01:04 PM
  4. Access & Excel - passing values
    By parry in forum PressF1
    Replies: 2
    Last Post: 01-08-2002, 05:54 PM
  5. Excel #n/a values
    By in forum PressF1
    Replies: 0
    Last Post: 15-04-2000, 05:30 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
  •