title: Ignore row if all 4 cells are 0; get name if any of the 4 cells is greater than 0
body: <p>i have a list of names(Column A), the numbers in columns B to F are result of a formula. I'm trying to create a FOR LOOP code that will check columns B to F, if all cells in B to F are zero then the code should ignore the current row and skip to the next row; if any of the cells in columns B to F is greater than 0, then the code should get the corresponding name in Column A.</p>
  
  <p><strong>Example:</strong> <em>If any of the cells in B2, C2, D2, and E2 is greater than 1, then i should get the name/value of A2. if all cells in B2, C2. D2, and E2 are all zeros, then proceed to check next row and do the same thing.</em></p>
  
  <p>here's the code i used to try to get the names that has any of the 4 column cell values greater than 1</p>
  
  <pre><code>     For i = 2 To LastCalcAnalystRowIndex '//wsCalculations.Cells(Rows.Count, "CP").End(xlUp).Row
  
      '//Get Component from cell in column "BP"
          Analyst = wsCalculations.Cells(i, "CP").Value
          Component = wsCalculations.Cells(i, "CN").Value
          weeknumber = wsCalculations.Range("BR2").Value + 3
  
              If wsCalculations.Cells(i, "B").Value = 0 And wsCalculations.Cells(, "C").Value = 0 _
              And wsCalculations.Cells(i, "D").Value = 0 And wsCalculations.Cells(i, "E").Value = 0 _
              And wsCalculations.Cells(i, "F").Value = 0 Then
              Exit For
              Else
              wsCalculations.Cells(i, "A").Value = wsCalculations.Cells(i, "CP").Value
              End If
              Next
  </code></pre>
  
  <p>using the code above, i tried to get the names which all 4 column values are not equal to zero, but the result i get is just a copy of the original list. i highlighted the rows i want my code to skip. i also included the result i get and the result i want to get. 
  Below is a sample data. My original data has 54 rows. <a href="https://i.stack.imgur.com/wlQwD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wlQwD.png" alt="data"></a>.
  can anyone please tell me what im getting wrong?</p>