| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell format - remove cell format pattern without effecting colors
Is it possible to remove a pattern from a cell row without effecting the
(multiple) cell colors |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell format - remove cell format pattern without effecting colors
You can change the pattern for all cells without changing the color using the
following property in VBA. You just have to set the range to cycle through. ..interior.Pattern = xlSolid -- Regards, Eddie http://www.HelpExcel.com "Bas" wrote: Is it possible to remove a pattern from a cell row without effecting the (multiple) cell colors |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format if cell value 0 pattern red value blank nothing | Excel Worksheet Functions | |||
| To format a cell pattern by VBA | New Users to Excel | |||
| Cell colors on conditional format | Excel Discussion (Misc queries) | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
| custom cell pattern colors | Excel Worksheet Functions | |||
Hybrid Mode
