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.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"MWS123" wrote:

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