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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Pattern Without Affecting Cell Color or Gridlines 8
Want to keep the pattern, not the fill 2
cell pattern - color 2
removing cell pattern 3
How to filter rows data based on background color of individual cells 1
Cell color and conditional formatting 2
Format Painter overwrites text 4
Excel VBA 1

Back
Top