Thread: change color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sunilpatel sunilpatel is offline
external usenet poster
  
Posts: 57
Default change color
i have merged cell in this rang, when sheet is protecetd (cells B2:J4 are
obviously not) the following does not work
Any ideas

Range("B2:J4").Interior.ColorIndex = 36


Reply With QuoteReply With Quote