Counting unique formats in a workbook

M

MWS123

I'm trying to clean up a workbook which has too many formats in it. Is there
a way of counting how many unique formats exist in each worksheet? I'd like
to know how many formats per sheet so that I can make a better decision on
which ones to clean up first.

Regards,

Mike
 
G

galimi

Excellent question (which I don't have the answer to). Here is what I would
do.

Cycle through all the sheet objects in the workbook, cycling through the
usedrange objects and inspecting the numberformat cell.
 

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

too many formats 0
Too many different formats and Userforms 4
Different Page Numbers or Number Formats for Different Sections 1
Numbered list problem 6
What is going on here? (macro mystery) 3
populate a combobox based on unique values in another workbook 16
Upload Excel formats to database 4
cells.interior.color values 3

Top