title: Excel VBA - Range.Clear does not clear cell
body: <p>I have the following function in my VBA which tries to clear the cell A1 in Excel Sheet1, but it does not clear the contents and also returns False as output:</p>
  
  <pre><code>Function test()
      Application.Volatile (False)    
      test = Worksheets("Sheet1").Range("A1:A1").Clear
  End Function
  </code></pre>
  
  <p>Also please not the Locked property is True at this time and even if I make it False, the next line if I print it, the Locked property is True.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks</p>