title: looping through a range of cells
body: <p>I need to run the function AddColumnofData on each cell from c27 and every contiguous non empty cell to the right, but I get a "Run-time error 424 object required", any help woul dbe greatly appreciated.</p>
  
  <pre><code>Set col = Range("$C$27", Range("$C$27").End(xlToRight))
  
  For Each c In col
      AddColumnofData (c)
  Next c
  </code></pre>