| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting unique formats in a workbook
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting unique formats in a workbook
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Formats | Excel Worksheet Functions | |||
| Counting cell formats | Excel Discussion (Misc queries) | |||
| Counting Conditional Formats | New Users to Excel | |||
| Counting Conditional Formats | Excel Programming | |||
| Formulas for...1. Counting unique cells 2. Display unique contents | Excel Programming | |||
Hybrid Mode
