Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to find all the cells in a worksheet/workbook that use a
particular style? I can only think of looping over all cells but that will be far too slow for the size of workbooks I have. The problem I have is that I want to be able to change the number format on all cells that have the Total style. The Total style though doesn't include a number format currently, and instead will be either a number or percentage depending on how the user has configured it. I need to update the decimal places used in the cells, so was going to write a tool to look at all cells with the Total style. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to stop style for col A changing to style of co D date vs $ | Setting up and Configuration of Excel | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
How do I convert US style dates to European style? | Excel Discussion (Misc queries) | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
Select Cells by Style | Excel Programming |