I get error message saying that there are too many cell formats.
Is there a limit to the number of cell formats in a workbook or a cell or a
sheet ?
If there is a limit what is it and how can I keep track of the number of
formats ?
Thanks. Mike

Mike

"Too many cell formats"

http://support.microsoft.com/default...b;en-us;213904

For code to count formats see this google search thread.

http://snipurl.com/h40s


Gord Dibben Excel MVP



On Sun, 21 Aug 2005 05:56:14 -0700, "Mike"
wrote:

I get error message saying that there are too many cell formats.
Is there a limit to the number of cell formats in a workbook or a cell or a
sheet ?
If there is a limit what is it and how can I keep track of the number of
formats ?
Thanks. Mike