title: Difficulty working with ranges and native Excel formulas in VBA
body: <p>I have a decent sized worksheet and I want to delete/clear the contents of any empty cells. They don't have a space or any character that I can see (<code>Len()</code> returns a zero) and they're being counted by <code>Counta</code>.</p>
  
  <p>Here's the macro I've developed, it's supposed to clear the contents of each cell in the selection that has a length of zero:</p>
  
  <pre><code>Sub NoNull()
  Dim rCell As Range
  Dim iLen As Integer
   For Each rCell In Selection
      iLen = WorksheetFunction.Len(Range(rCell))
      If iLen = 0 Then rCell.ClearContents
   Next rCell
  End Sub
  </code></pre>
  
  <p>I get an error on this line:</p>
  
  <p><code>iLen = WorksheetFunction.Len(Range(rCell))</code></p>
  
  <p>I ASSUME it's related to the way I input the rCell into the <code>Len</code> formula.</p>