title: Inputting a formula over a column
body: <p>I have this formula <code>=1+ LEN(AT2) - LEN(SUBSTITUTE(AT2, "+", ""))</code> that I want to apply over a column AU, that dynamically changes the variable (AT2 in this case) as iterates to the next row e.g. AT2, AT3, AT4.  </p>
  
  <p>Currently, this code keeps getting thrown an  </p>
  
  <blockquote>
    <p>application/object error  </p>
  </blockquote>
  
  <p>and I can't seem to get around it. Essentially what I want the formula to do is count the number of "+" that occur in the column before and add 1 to that number. Any help would be great! Thanks in advance.</p>
  
  <pre><code>With wsIt
      Range("AU2:AU" &amp; LastRow).Formula = "=LEN(AT2) - LEN(SUBSTITUTE(AT2, " + ", ""))"
  End With
  </code></pre>