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

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
(E-Mail Removed)
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