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

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