+ Reply to Thread
Results 1 to 9 of 9

Hyperlinks - title in A and URL in D column

  1. #1
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    89

    Question Hyperlinks - title in A and URL in D column

    i tried to compile excel VBA to make text in column A with hyperlinks to URL found in column D
    the range is formatted as table and the name is T_RAW
    any ideas how to fix this or what other approach i can go with ?


    Please Login or Register  to view this content.

    unfortunately i get
    Please Login or Register  to view this content.
    for the row
    Please Login or Register  to view this content.
    Last edited by godlev; 12-17-2018 at 12:24 PM. Reason: SOLVED
    Truth fears no questions.

  2. #2
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    89

    Re: Hyperlinks - title in A and URL in D column

    anyone help me on this ?

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,613

    Re: Hyperlinks - title in A and URL in D column

    Where do you want to add the hyperlinks?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    89

    Re: Hyperlinks - title in A and URL in D column

    A:A = contains just short titles
    B:B = random info
    C:C = random info
    D:D = contains hyperlinks like (http://google.com etc.)

    i want VBA to get the link from D1 and make A1 pointing to that link then D2 to A2 and D3 to A3 and continue like that for each row

  5. #5
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    89

    Re: Hyperlinks - title in A and URL in D column

    anyone has ideas how to solve this or another approach?

  6. #6
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Hyperlinks - title in A and URL in D column

    Can you provid the sample excel for futher clear help on this.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  7. #7
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    89

    Re: Hyperlinks - title in A and URL in D column

    attached url-sample.xlsx file - hope its clear now
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Hyperlinks - title in A and URL in D column

    Here you go:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    89

    Re: Hyperlinks - title in A and URL in D column

    works like charm - solved! - thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-29-2018, 10:20 PM
  2. Make unique Title in Column F if Column A match [VBA]
    By paul_j_ in forum Excel General
    Replies: 8
    Last Post: 06-09-2015, 04:29 AM
  3. Adding ROW using 1 column as reference and another column for naming - BAD title
    By dbondmelo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 12:05 PM
  4. Return the Title of a column if the column is the highest column with data
    By williamspage in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-22-2013, 10:05 AM
  5. Find Hyperlinks, Copy Hyperlinks to alternative sheet, print all hyperlinks
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 05:13 PM
  6. Replies: 4
    Last Post: 10-19-2012, 12:09 PM
  7. Replies: 2
    Last Post: 07-21-2006, 05:10 AM

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