cell format -> remove cell format pattern without effecting colors

  • Thread starter Thread starter Bas
  • Start date Start date
B

Bas

Is it possible to remove a pattern from a cell row without effecting the
(multiple) cell 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
 
Back
Top