Extracting info from hyperlink

0 votes
I have a column with more than 200 hyperlinks. Every link point to a sheet in the same file. Is there a way to write the sheet's name in another column to which the hyperlink points?

For example, the First link opens the sheet10, so I want to write in the column on the right "Sheet10"
Feb 2, 2023 in Others by Kithuzzz
• 38,020 points
321 views

1 answer to this question.

0 votes

This will offer you an example of how to list the hyperlink targets using VBA:

Sub ListLinks()
    Dim oHl As Hyperlink
    Dim oWs As Worksheet
    For Each oWs In ActiveWorkbook.Worksheets
        For Each oHl In oWs.Hyperlinks
            'Debug.Print oHl.Address
            Debug.Print oHl.SubAddress
        Next
    Next
End Sub
answered Feb 2, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Extracting tabular data from multiple .xlsx files with inconsistent structures

For a cell that is consistent across ...READ MORE

answered Mar 25, 2023 in Others by narikkadan
• 63,720 points
564 views
0 votes
1 answer

Extracting a Variable Number of Letters from a Formula using VBA Code

Please, try the next function: Function extractLetter(rng As ...READ MORE

answered Mar 26, 2023 in Others by Kithuzzz
• 38,020 points
370 views
0 votes
1 answer

How is regression testing different from functional testing?

Functional testing is testing a section of code ...READ MORE

answered Feb 18, 2019 in Others by Mythlli
655 views
0 votes
1 answer

Opening Selected Hyperlink DISPLAYING TEXT in Default Browser in MS Excel

Try this code: Sub Open_SelectedTextlinks() If Not ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,720 points
683 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,099 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,524 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
824 views
0 votes
1 answer
0 votes
1 answer

Hyperlink changes from # to %20-%20 when clicked in Excel

This is a known issue with MS Excel. Basically, ...READ MORE

answered Nov 19, 2022 in Others by narikkadan
• 63,720 points
681 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP