title: I am not able to clear and reset the background color of a Cell
body: <p>With the help of the below command I am able to clear the contents of the cells but not their background color. How to clear and set the background color of cells in a range?</p>
  
  <pre><code>ob9.Range(ob9.Cells(1,StartCol),ob9.Cells(1,maxcolumn)).ClearContents
  </code></pre>
  
  <p><strong><em>EDIT</em></strong></p>
  
  <p>I tried the below :</p>
  
  <pre><code>CountFill = objExcel1.Application.WorksheetFunction.CountA(ob9.Rows(1))
  CountBlnk = objExcel1.Application.WorksheetFunction.CountBlank(ob9.Rows(1))
  TotalColumn= CountBlnk + CountFill
  
  ob9.Range(ob9.Cells(1,CountFill + 1 ),ob9.Cells(1,TotalColumn)).Interior.ColorIndex(-4142) '= xlColorIndexNone
  </code></pre>
  
  <p>Can it be done in a single line?</p>
  
  <p>Thanks</p>