Guest User

Untitled

a guest
Jan 18th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. Sub test()
  2. Dim arm(11, 1) As Variant
  3. Dim tempar() As Variant
  4. ReDim tempar(0 To UBound(arm, 1), 0 To UBound(arm, 2)) As Variant
  5.  
  6. arm(0, 0) = "banana"
  7. arm(1, 0) = "banana"
  8. arm(2, 0) = "banana"
  9. arm(3, 0) = "apple"
  10. arm(4, 0) = "apple"
  11. arm(5, 0) = "banana"
  12. arm(6, 0) = "cucumber"
  13. arm(7, 0) = "cucumber"
  14. arm(8, 0) = "cucumber"
  15. arm(9, 0) = "apple"
  16. arm(10, 0) = "cucumber"
  17. arm(11, 0) = "a"
  18.  
  19. arm(0, 1) = 5
  20. arm(1, 1) = 4
  21. arm(2, 1) = 3
  22. arm(3, 1) = 2
  23. arm(4, 1) = 5
  24. arm(5, 1) = 3
  25. arm(6, 1) = 2
  26. arm(7, 1) = 4
  27. arm(8, 1) = 5
  28. arm(9, 1) = 1
  29. arm(10, 1) = 1
  30. arm(11, 1) = 3
  31.  
  32. tempar() = unqfiladv(arm)
  33.  
  34. End Sub
Add Comment
Please, Sign In to add comment