title: Is there a Cells().Formula function?
body: <p>my script compiled fine so I assumed it was ok but couldn't find it and of course it error's out on this line, this is encapsolated in a while loop, I'm just trying to have a simple way to add a formula to a row of data, then do something similar to add it to a row of data. Is there no .Formula or do I have another error?</p>
  
  <pre><code>Cells(arow, acol).Formula = "=COUNTIF(" &amp; wsData.Name &amp; "!" &amp; Cells(fdRow, acol).Address &amp; ":" &amp; Cells(ldRow, acol) &amp; ")"
  acol = acol + 1
  </code></pre>