title: VBA Issue with If/And/Then/Else statement using ActiveCell..Offset(-1,0)=
body: <p>I would like to select a cell in column C and check if the two cells above it are equal to 0. If they are equal to 0, I would like the ActiveCell to equal 1 Else I would like the ActiveCell to equal 0. I would then like to select the cell that is down 3 from the initial cell and repeat the process. I would like to do this 773 times. The issue I'm having is with the IF/AND section, it is always selecting 0 even when it should select a 1. Any idea what I did wrong. Working in an excel file that was converted from a CSV.</p>
  <pre><code>Range(&quot;C4&quot;).Select
  
  For i = 1 To 773
  
  If ActiveCell.Offset(-1, 0).Value = “0” And ActiveCell.Offset(-2, 0).Value = “0” Then 
      ActiveCell = &quot;1&quot; Else
          ActiveCell = &quot;0&quot;
  
  ActiveCell.Offset(3, 0).Select
  
  Next i
  </code></pre>