title: Excel VBA If then statements
body: <p>i want to if my cell (b5,c5) is blank than cell (f5,g5,h5) also make blank also ,cell (b6,c6) is blank than cell (f6,g6,h6) ,cell (b7,c7) is blank than cell (f7,g7,h7) ,cell (b8,c8) is blank than cell (f8,g8,h8) ,cell (b9,c9) is blank than cell (f9,g9,h9) ,  but same in i want this code 200 time help me make a small code.thanks in advance.</p>
  
  <pre><code>Sub BLANK()
  
      If Range("B5,C5") = "" Then
      Range("F5,G5,H5") = ""
      If Range("B6,C6") = "" Then
      Range("F6,G6,H6") = ""
      If Range("B7,C7") = "" Then
      Range("F7,G7,H7") = ""
      ' same code in cell("b5:b200") make small code please
       end if
    end sub
  </code></pre>