title: VBA Runtime Error : Clear Contents of an Excel sheet
body: <p>I have written following VBA code in Excel 2003 to clear the contents of an excel sheet;
  But it shows </p>
  
  <blockquote>
    <p>RunTime Error 438: Object doesn't Support this property or Method</p>
  </blockquote>
  
  <p>Here is my code,</p>
  
  <pre><code>Application.DisplayAlerts = False
  Application.ScreenUpdating = False
  
  Set wbk = Workbooks.Open("C:\a.xls")
  wbk.Sheet1.Cells.ClearContents 'Error at this line
  wbk.Save
  wbk.Close
  
  Application.DisplayAlerts = True
  Application.ScreenUpdating = True
  </code></pre>
  
  <p>Could any one please let me know if <strong>wbk.Sheet1.Cells.ClearContents</strong> is not supported when excel is invisible. How can I clear content of an excel sheet when it is invisible?</p>