Results 1 to 2 of 2

Hyperlink adding directory info??

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2012
    Location
    Harrisburg, Pennsylvania
    MS-Off Ver
    Excel 2010
    Posts
    17

    Hyperlink adding directory info??

    I am using this code so every time I need to add a hyperlink I can add to a list easily and automatically. It used to work fine but now it adds the workbook directory to it. If I enter the website as "www.yahoo.com" I get an error when I try to click on the hyperlink because it shows to be linked to "File:///G:\New Folder\www.yahoo.com" When I try to edit hyperlink it shows "Existing File Or Web site is clicked,and address is "www.yahoo.com"???? What am I doing wrong?

    HLink = InputBox("What is the website")
    Sheets("Grab Lists").Activate
    Range("M500").End(xlUp).Offset(1, 0).Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=HLink, TextToDisplay:=CellText
    Please help this is driving me crazy!!!

    Thank you in advance

    UPDATE: I figured it out.... turns out I MUST enter HTTP:// first. Sorry and thank you.
    Last edited by arlu1201; 12-16-2012 at 02:06 PM. Reason: I figured it out

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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