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

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

http://groups.google.com/groups?selm...GP11.phx.gb l

--
Regards,
Tom Ogilvy


"knight4 " wrote in message
...
I have a large workbook (47 worksheets), that uses a large amount of
different cell formats. The file has been developed by a few people and
as a result the formatting is not as consistant as it should be. I am
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 find
all cells with the same format. I can then loop through each cell to
determine how many different cell formats I am using. Basically, I need
to know how close to the limit of 4000 formats I am. Part of the file
is a gannt chart that is created automatically using vbs, and it fails
if i run out of formats during the creation. Does anyone know a way I
can achieve this? Any help would be appreciated.


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

Some additional info:

http://support.microsoft.com/default...04&Product=xlw
XL: Error Message: Too Many Different Cell Formats


http://support.microsoft.com/default...22&Product=xlw
XL97: "Out of Memory" Error When You Open an Excel Workbook

--
Regards,
Tom Ogilvy

"knight4 " wrote in message
...
I have a large workbook (47 worksheets), that uses a large amount of
different cell formats. The file has been developed by a few people and
as a result the formatting is not as consistant as it should be. I am
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 find
all cells with the same format. I can then loop through each cell to
determine how many different cell formats I am using. Basically, I need
to know how close to the limit of 4000 formats I am. Part of the file
is a gannt chart that is created automatically using vbs, and it fails
if i run out of formats during the creation. Does anyone know a way I
can achieve this? Any help would be appreciated.


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

Thanks for the information Tom..I appreciate it.

Regards

Knight

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