Too Many Custom formats

[Russell Pennington]

When trying to format cells, I get an error message that
says "Too many custom formats."

Is there any fix for this other than deleting existing
custom formats?

 

[Jason Morin]

See:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

HTH
Jason
Atlanta, GA

 

[Doug Kanter]

No idea, but how many custom formats do you have in the worksheet in
question?

 

[David McRitchie]

Leo Heuser has code to eliminate unused formats see links in
http://www.mvps.org/dmcritchie/excel/slowresp.htm
for both original code and his updated code.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm