ExcelBanter - code/command to count the number of fonts

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - code/command to count the number of fonts (https://www.excelbanter.com/excel-programming/340301-code-command-count-number-fonts.html)

vbaprog

code/command to count the number of fonts

I need to count the number of fonts used in my workbook in order to prevent
my program from crashing when the fonts count exceeds 255 which is the
maximum number of fonts allowed in an excel workbook. Is there a code or
command to count the number of fonts used in an excel workbook?

All times are GMT +1. The time now is 04:17 PM.