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/E...tyleMapper.htm

Robin Hammond
www.enhanceddatasystems.com


"Manos" wrote in message
...
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