Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |