Thread: Value to be given to all cells with black background color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
147man 147man is offline
external usenet poster
  
Posts: 5
Default Value to be given to all cells with black background color
for each c in selection.cells
if c.interior.colorindex=1 then c.value=1
next c

Reply With QuoteReply With Quote