cell format -> remove cell format pattern without effecting colors

B

Bas

Is it possible to remove a pattern from a cell row without effecting the
(multiple) cell colors
 
H

HelpExcel.com

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
 
Top