title: Excel VBA, Checking for value from a cell in the same row
body: <p>I have a macro that needs to check if there is a 1 in a cell from the same row. The problem I have is that I need to do that for a range of 3 columns.</p>
  
  <p>Actually, this part doesn't work at all but I can put it in cells form.</p>
  
  <p>I need to check for all the cells from ("P3:R" &amp; iNbKids) if there is a 1 in the cell ("K" &amp; ActiveCell.Row). I have tried a lot of things but I can't seem to figure it out.</p>
  
  <p>iNbKids is an Integer</p>