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.
.
|