title: Excel VBA Expected Array
body: <p>I have three blocks of code, all identical except the variables they reference. However, the "Wrep" block is complaining of a compile error on Wrep_match saying "Expected Array". I can't see any difference between the Wrep and Orep blocks:</p>
  
  <pre><code>        If Orep_name = "" Then
              If reps.exists(Orep_number) Then
                  Orep_match = Split(reps(Orep_number), ",")
                  If IsArray(Orep_match) Then
                      Orep_name = Orep_match(0)
                      Orep_team = Orep_match(1)
                  End If
              End If
          End If
  
          If Wrep_number &lt;&gt; "" And Wrep_number &lt;&gt; "0" Then
              If reps.exists(Wrep_number) Then
                  Wrep_match = Split(reps(Wrep_number), ",")
                  If IsArray(Wrep_match) Then
                      Wrep_name = Wrep_match(0)
                      Wrep_team = Wrep_match(1)
                  End If
              End If
          End If
  </code></pre>