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
 

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

Excel does not accept text format! 0
Transfer data between two tables 3
Tracked changes by multiple people modified to one 0
Remove Pattern Without Affecting Cell Color or Gridlines 7
WIERD GLITCHED/ERROR IMAGE HELP APRECIATED! 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change the colour of a neighbouring cell 6
Excel Formatting 4

Top