title: how to get a 'Cell' object in excel VBA
body: <p>So i was using a for each loop to go through a bunch of rows. I ran into a problem where i was deleting rows and it was causing a row to get skipped so i have changed to a do while loop.</p>
  
  <p>The problem i am having is trying to get a 'cell' object. Before when i had:</p>
  
  <pre><code>For Each C In Worksheets("Blah").Range("A2:A" &amp; lastRow).Cells
  </code></pre>
  
  <p>I could do things like </p>
  
  <pre><code>C.Offset(1, 0)
  C.Value = "Troy"
  </code></pre>
  
  <p>Etc. I tried using:</p>
  
  <pre><code>C = Worksheets("Blah").Cells(iRow, 2)
  </code></pre>
  
  <p>but that just gives C the value of the cell. How do i get the actual cell object?</p>
  
  <p>Thanks</p>