1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to bulk open links in excel

Discussion in 'BlackHat Lounge' started by Merlin22, Sep 12, 2015.

  1. Merlin22

    Merlin22 Regular Member

    Joined:
    May 19, 2010
    Messages:
    214
    Likes Received:
    32
    Does anybody know of an add-on or macro that would allow me to open a selection of url's in column B of an excel spreadsheet. I'd like to be able to select the cells that I want opened in Chrome. I tried the following code, but got an error message that I don't understand. Thanks.

    Sub Open_Hyperlinks()
    Dim i, LastRow
    LastRow = Range("B" & Rows.Count).End(xlUp).Row
    For i = 1 To LastRow
    If Cells(i, "B").Hyperlinks.Count > 0 Then
    Cells(i, "A").Hyperlinks(1).Follow
    End If
    Next
    End Sub