我有一堆数组:
my1_L = Array(5, 17, 29, 41, 53, 65, 77, 89, 101, 113, 125, 137)
my1_R = Array(6, 18, 30, 42, 54, 66, 78, 90, 102, 114, 126, 138)
my2_L = Array(7, 19, 31, 43, 55, 67, 79, 91, 103, 115, 127, 139)
my2_R = Array(8, 20, 32, 44, 56, 68, 80, 92, 104, 116, 128, 140)
my3_L = Array(1, 13, 25, 37, 49, 61, 73, 85, 97, 109, 121, 133)
my3_R = Array(9, 21, 33, 45, 57, 69, 81, 93, 105, 117, 129, 141)
my4_L = Array(2, 14, 26, 38, 50, 62, 74, 86, 98, 110, 122, 134)
my4_R = Array(10, 22, 34, 46, 58, 70, 82, 94, 106, 118, 130, 142)
my5_L = Array(3, 15, 27, 39, 51, 63, 75, 87, 99, 111, 123, 135)
my5_R = Array(11, 23, 35, 47, 59, 71, 83, 95, 107, 119, 131, 143)
my6_L = Array(4, 16, 28, 40, 52, 64, 76, 88, 100, 112, 124, 136)
my6_R = Array(12, 24, 36, 48, 60, 72, 84, 96, 108, 120, 132, 144)
都是myX_L或者myX_R的命名方式,我想循环查询任意一个数字在这些一维数组中的位置,如果循环执行的话,那些一维数组可以怎么简化表示?
for i=1 to 6
for j=0 t0 11
if a=my&i&"_L"(j) then
红色表述部分的书写格式时候错误的,小弟请问下应该怎么修改?便于循环查询,谢谢!
- Sub test()
- Dim my_L(1 To 6), my_R(1 To 6)
- my_L(1) = Array(5, 17, 29, 41, 53, 65, 77, 89, 101, 113, 125, 137)
- my_R(1) = Array(6, 18, 30, 42, 54, 66, 78, 90, 102, 114, 126, 138)
- my_L(2) = Array(7, 19, 31, 43, 55, 67, 79, 91, 103, 115, 127, 139)
- my_R(2) = Array(8, 20, 32, 44, 56, 68, 80, 92, 104, 116, 128, 140)
- my_L(3) = Array(1, 13, 25, 37, 49, 61, 73, 85, 97, 109, 121, 133)
- my_R(3) = Array(9, 21, 33, 45, 57, 69, 81, 93, 105, 117, 129, 141)
- my_L(4) = Array(2, 14, 26, 38, 50, 62, 74, 86, 98, 110, 122, 134)
- my_R(4) = Array(10, 22, 34, 46, 58, 70, 82, 94, 106, 118, 130, 142)
- my_L(5) = Array(3, 15, 27, 39, 51, 63, 75, 87, 99, 111, 123, 135)
- my_R(5) = Array(11, 23, 35, 47, 59, 71, 83, 95, 107, 119, 131, 143)
- my_L(6) = Array(4, 16, 28, 40, 52, 64, 76, 88, 100, 112, 124, 136)
- my_R(6) = Array(12, 24, 36, 48, 60, 72, 84, 96, 108, 120, 132, 144)
- For i = 1 To 6
- For j = 1 To 11
- If a = my_L(i)(j) Then
-
- End If
- Next
- Next
- End Sub
复制代码
|