title: Button execution from Userform throwing Subscript out of Range error
body: <p>Button for the code was previously present in the Excel Sheet, tested and executed successfully. Now I have shifted that button to a Userform, when executed I get an error </p>
  
  <blockquote>
    <p>subscript out of Range</p>
  </blockquote>
  
  <p>When Step Debugging is used
  error occurs at line 1</p>
  
  <pre><code>Worksheets("Sheet1").Columns(5).ClearContents
  </code></pre>
  
  <p>I cant figure out the fault.</p>
  
  <pre><code>Private Sub OUTCLR_Click()
      Worksheets("Sheet1").Columns(5).ClearContents
      Worksheets("Sheet1").Columns(2).ClearContents
      Sheet1.Cells(1, 5).Value = "RESULT"
      Sheet1.Cells(1, 2).Value = "PROCESSED UNIQUE STRINGS"
  End Sub
  </code></pre>