code/command to count the number of fonts

V

vbaprog

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Need help modifying code 0
Printing Outline view - formatting lost 0
How to count the numbers in a Word document? 0
How to change font & size of (all) citation numbers? 7
Section and Page numbering 0
How to modify and updte specific styles for specific paragraphs across the document 0
Object Browser in VBA 0

Top