I have a large workbook (47 worksheets), that uses a large amount o
different cell formats. The file has been developed by a few people an
as a result the formatting is not as consistant as it should be. I a
now getting the "too many different cell formats" error.
I am looking for a way to use vba to look at a particular cell and fin
all cells with the same format. I can then loop through each cell t
determine how many different cell formats I am using. Basically, I nee
to know how close to the limit of 4000 formats I am. Part of the fil
is a gannt chart that is created automatically using vbs, and it fail
if i run out of formats during the creation. Does anyone know a way
can achieve this? Any help would be appreciated

--
Message posted from http://www.ExcelForum.com