ExcelBanter - count cell styles

Hi,

ActiveWorkbook.Styles.Count will do the trick.

Ecco

-----Original Message-----
Howdy all.

Is there a way to count how many cell styles there r in a
sheet? I know Excel(2000) has a built in limitation of
4,000.

I have a macro that combines between 40-90 sheets (from
multiple workbooks) together in one workbook.
Once it reaches the limitation the macro crashes.
Therefore i need to design a counter to let me know, if
the limitation will be reached or not.

Cheers.
Russ.
.