title: for each loop through a case statement
body: <p>I have this code and I'm trying to remove rows where case 0 - 7 are all zero's.  Is it better to do a for loop, or use if-then?:</p>
  
  <pre><code>tmpEditRow.BeginEdit()
  
              Select Case a
                  Case 0
                      tmpEditRow("Qsold / QoH1") = QtySold &amp; " / " &amp; QtyOH
                  Case 1
                      tmpEditRow("Qsold / QoH3") = QtySold &amp; " / " &amp; QtyOH
                  Case 2
                      tmpEditRow("Qsold / QoH4") = QtySold &amp; " / " &amp; QtyOH
                  Case 3
                      tmpEditRow("Qsold / QoH7") = QtySold &amp; " / " &amp; QtyOH
                  Case 4
                      tmpEditRow("Qsold / QoH8") = QtySold &amp; " / " &amp; QtyOH
                  Case 5
                      tmpEditRow("Qsold / QoH10") = QtySold &amp; " / " &amp; QtyOH
                  Case 6
                      tmpEditRow("Qsold / QoH12") = QtySold &amp; " / " &amp; QtyOH
                  Case 7
                      tmpEditRow("Qsold / QoH14") = QtySold &amp; " / " &amp; QtyOH
               End Select
                      tmpEditRow.EndEdit()
  </code></pre>