Macro after Web refresh

[JTL9161]

I have a spreadsheet that imports a web page that I extract data from. Being its a daily refresh the page has older yet duplicate information farther down the page that also imports. I am trying to run a macro that will search for the previous day on the page (=today()-1) in Wed, Apr 10, 2019 format and clear the contents from that cell to the bottom of the spreadsheet. I have the macro but cannot get it to run AFTER the refresh is completed.

Any help will be appreciated.
James

 

[John_w]

Follow the steps at https://www.excelandaccess.com/create-beforeafter-query-update-events/ and call your macro from the MyQuery_AfterRefresh procedure.