Results 1 to 9 of 9

Hyperlinks - title in A and URL in D column

Threaded View

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

    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 ?


    Sub update()
    
    Dim row As Range
    Dim tbl As ListObject
    
    Set tbl = ActiveSheet.ListObjects("T_RAW")
    
    For Each row In [T_RAW].Rows
    With tbl
    .Hyperlinks.Add Anchor:=row.Columns(1), _
     Address:=row.Columns(4), _
     ScreenTip:=row.Columns(1), _
     TextToDisplay:=row.Columns(1)
     End With
    Next
    
    End Sub

    unfortunately i get
    object required
    for the row
    For Each row In [T_RAW].Rows
    Last edited by godlev; 12-17-2018 at 12:24 PM. Reason: SOLVED
    Truth fears no questions.

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. [SOLVED] Named range=Column title,comumn title in cellB6 use B6in equation
    By Graham in forum Excel General
    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