Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. ARRAY_1A = [a100, a200, a300, a400, a500]
  2. ARRAY_1B = [b100, b200, b300, b400, b500]
  3. ARRAY_1C = [c100, c200, c300, c400, c500]
  4. ARRAY_1D = [d100, d200, d300, d400, d500]
  5. ARRAY_1E = [e100, e200, e300, e400, e500]
  6.  
  7. ARRAY_2A = [a100, a300, a200]
  8. ARRAY_2B = [b100, b300, b200]
  9. ARRAY_2C = [c100, c300, c200]
  10. ARRAY_2D = [d100, d300, d200]
  11. ARRAY_2E = [e100, e300, e200]
  12.  
  13. [a400, b400, c400, d400, e400]
  14. [a500, b500, c500, d500, e500]
  15.  
  16. Dim j As Long
  17. Dim i As Long
  18. For j = LBound(ARRAY_1A, 1) To UBound(ARRAY_1A, 1)
  19. For i = LBound(ARRAY_2A) To UBound(ARRAY_2A)
  20. If ARRAY_1A(j, 1) = ARRAY_2A(i, 1) And _
  21. ARRAY_1B(j, 1) = ARRAY_2B(i, 1) And _
  22. ARRAY_1C(j, 1) = ARRAY_2C(i, 1) Then
  23. 'Exit For
  24. GoTo Lavel1
  25. ElseIf i = UBound(ARRAY_2A) Then
  26.  
  27. Debug.Print ARRAY_1A(j, 1), _
  28. ARRAY_1B(j, 1), _
  29. ARRAY_1C(j, 1), _
  30. ARRAY_1D(j, 1), _
  31. ARRAY_1E(j, 1)
  32.  
  33. End If
  34. Next i
  35.  
  36. ' End If
  37. Lavel1:
  38. Next j
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement