Font name and size

Hi guys;

I have a list of cells in column A$ and I need a macro to list the font name of each cell in column B$ and font size in column C$.

Thanks in advance.

Thanks man
It works with a sample data
But when i apply it on whole data, some of fonts name were
Missing while all font size was not there

Thanks man
It works with a sample data
But when i was apply it on whole data, some of fonts name were
Missing while all font size was not there

here is the data, I couldn't upload it seems something with web coding, you will note be able to see the words written as am using
custom fonts.

www.adanwater.com/data.xlsx

http://custom fonts. www.adanwater.com/data.xlsx

thanks man

Man
You are my hero.
😘😘😘
Thanks a lot