Thread: mergercell problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SUNIL SUNIL is offline
external usenet poster
  
Posts: 11
Default mergercell problem
How do you code to clear contents of a merged cell

I am trying

If CELL.Interior.ColorIndex = 36 Then CELL.ClearContents

i get an error if the cell is merged with the next cell (e.g B5 and C5)


Reply With QuoteReply With Quote