In this difficult time for all of us (I hope you are all well) I've invented live COVID cases macro if you want to add it somewhere (dashboards or something else....).
It is based on https://www.worldometers.info/coronavirus/
and getting info from your country subsite, like for me: https://www.worldometers.info/coronavirus/country/uk/
For most of countries it works well (because syntax of html is the same), just change you country (open you country from here: https://www.worldometers.info/coronavirus/#countries) and paste http address into sheet1 (cell A1).
I did not paste macro here as it contains html and firewall does allow me to do it even if I wrap it into html tag.
Necessary references:
Check attached file for details.
Bookmarks