title: Calling Another Code
body: <p>I am trying to figure out another way to write this line. Currently, I have it to where if any of the ranges AA2:AA7 = 1 then call code OneLineItem. Issue is, the parameter I need set is if only one of those cells equals 1 and only one other cell to be greater than 1. I.e. AA2 = 1 and AA7=200 (for example). A problem i'm running into is that AA2 = 1, AA3 = 100, AA7 = 200. However I just need one cell to equal 1 and another cell to be >1 and everything else to be 0. If that criteria is met, then call code OneLineItem. Thank You.</p>
  
  <pre><code>    If ActiveSheet.Range("AA2") = 1 Or ActiveSheet.Range("AA3") = 1 Or 
      ActiveSheet.Range("AA4") = 1 Or ActiveSheet.Range("AA5") = 1 Or 
      ActiveSheet.Range("AA6") = 1 Or _
      ActiveSheet.Range("AA7") = 1 Then
      Call OneLineItem
      Else
  </code></pre>