Too many different format cell

[Guest]

Dear All
there is anyway to make a macro that can calculate the format cell per sheet?
Because i have i worksheet where i have an error message "to many different
format cells" and because it is quite big, if there is anyway to make a macro
to calculate the format per sheet?

Thanks in advance

 

[Robin Hammond]

Manos,

I am not sure if this will help with your exact problem, but I have a Style
Mapper utility on my site that helps you get rid of unwanted styles, and
remap styles onto others. It was done in response to this kind of problem.

http://www.enhanceddatasystems.com/ED/Pages/ExcelStyleMapper.htm

Robin Hammond
www.enhanceddatasystems.com