Thread: cell format - remove cell format pattern without effecting colors
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HelpExcel.com[_2_] HelpExcel.com[_2_] is offline
external usenet poster
  
Posts: 39
Default cell format - remove cell format pattern without effecting 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
--
Regards,
Eddie
http://www.HelpExcel.com


"Bas" wrote:

Is it possible to remove a pattern from a cell row without effecting the
(multiple) cell colors
Reply With QuoteReply With Quote