too many different cell formats problem

[knight4]

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

 

[Tom Ogilvy]

Leo Heuser has done some work in this area which you might be able to adapt:

http://groups.google.com/[email protected]

 

[Tom Ogilvy]

Some additional info:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904&Product=xlw
XL: Error Message: Too Many Different Cell Formats


http://support.microsoft.com/default.aspx?scid=kb;en-us;255622&Product=xlw
XL97: "Out of Memory" Error When You Open an Excel Workbook

 

[knight4]

Thanks for the information Tom..I appreciate it.

Regards

Knight