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.