| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Styles on Ribbon | Excel Discussion (Misc queries) | |||
| some unknown Cell styles are shown in cell styles | Excel Worksheet Functions | |||
| Excel Cell Styles - Quick Styles? | Excel Discussion (Misc queries) | |||
| New Cell Styles | New Users to Excel | |||
| Line styles for Cell Borders | Excel Discussion (Misc queries) | |||
Linear Mode
