View Full Version : Solved: How to count Cell Style used in a workbook
Emily
02-28-2006, 05:11 AM
Cell styles in a workbook < 4,000
How to count Cell Styles used in a workbook?
johnske
02-28-2006, 05:44 AM
MsgBox ActiveWorkbook.Styles.Count :)
Emily
02-28-2006, 06:00 AM
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
02-28-2006, 06:05 AM
It counts each unique style, not the number of cells that are using any of these styles :)
Emily
02-28-2006, 06:08 AM
Thanks
ps
No Solved in thread tool ?
johnske
02-28-2006, 07:23 AM
Not a prob (have reported the thread tool prob) :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.