Solved: How to count Cell Style used in a workbook

[Emily]

Cell styles in a workbook < 4,000

How to count Cell Styles used in a workbook?

[johnske]

MsgBox ActiveWorkbook.Styles.Count :)

[Emily]

johnske:

ActiveWorkbook.Styles.Count = 9

Is the limation "Cell styles in a workbook < 4,000" refer to these unique styles?

Or is it related to total number of cell styles used in all individual cells?

Thanks.
Emily

[johnske]

It counts each unique style, not the number of cells that are using any of these styles :)

[Emily]

Thanks


ps
No Solved in thread tool ?

[johnske]

Not a prob (have reported the thread tool prob) :)