| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cell formats
I'm going through the process of cleaning someone's ridiculous workbook of
it's cell formats - I just want to know if there is a line of code I can stick in the Immediate Window that will tell me how many cell formats I have? Thanks in advance Daniel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cell formats
ctrl + f | options | format | choose the formats | ok | find all
u can see the count of cells which matches the format u have choosen in the find format. On Oct 2, 7:25*pm, Daniel Bonallack wrote: I'm going through the process of cleaning someone's ridiculous workbook of it's cell formats - I just want to know if there is a line of code I can stick in the Immediate Window that will tell me how many cell formats I have? Thanks in advance Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| Counting Conditional Formats | New Users to Excel | |||
| Cell Formats | Excel Worksheet Functions | |||
| Copy and link formats from cell to cell | Excel Discussion (Misc queries) | |||
| CELL FORMATS | Excel Discussion (Misc queries) | |||
Linear Mode
