extract links from sheet?

falfuly

New Member
Joined
Oct 2, 2007
Messages
26
Hello,

I have an excel sheet that contains 300 entries .
Each entry is a name ‎of a website (that links to the website).

In order to create a Google Custom ‎Search Engine, <b>I need to copy only the links</b> and paste them into the ‎configuration panel of the search engine.

The problem is that when I copy the ‎entries, I can only paste the captions of the links, not the links themselves. ‎

Any solutions?

Thanks a lot! Eyal. ‎
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

nirvana_

Board Regular
Joined
Mar 25, 2009
Messages
141
Try this.

Assumes all hyperlinks are on sheet1.

Creates a new sheet called hyperlinks and puts all the urls into it.

Code:
Sub GetAddresses()
    Dim i As Integer
    Dim WS As Worksheet
    Set WS = Worksheets.Add
    WS.Name = "Hyperlinks"
    If Sheets("Sheet1").Hyperlinks.Count >= 1 Then
        For i = 1 To Sheets("Sheet1").Hyperlinks.Count
            WS.Cells(i, 1).Value = Sheets("Sheet1").Hyperlinks(i).Address
        Next
    End If
End Sub
 
Upvote 0

Forum statistics

Threads
1,191,587
Messages
5,987,506
Members
440,098
Latest member
MickyMouse123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top