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


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