Pull href inner text to excel sheet

  • Hi All,


    I need help in extracting href inner text values which are in <a title into excel sheet. I have included html code for your reference.


    I have also attached the excel file with output that i need in "Hvalues" tab. Macro which i used is mentioned below.




    Thanks for your help.

    TC