For x = 2 To 10
For y = 2 To 10
Select Case Range("a" & x)
Case "B"
k = k + 1
ReDim arr1(1 To k)
arr1(k) = Range("b" & x)
End Select
Next x
Next y
End Sub
十分简单:
Sub a()
Dim arr1(), x, k
For x = 2 To 10
Select Case Range("a" & x)
Case "B"
k = k + 1
ReDim Preserve arr1(1 To k)
arr1(k) = Range("b" & x)
End Select
Next
End Sub
或
Sub a()
Dim arr1(), x, k
For x = 2 To 10
If Range("a" & x) = "B" Then
k = k + 1
ReDim Preserve arr1(1 To k)
arr1(k) = Range("b" & x)
End If
Next
End Sub
十分简单:
Sub a()
Dim arr1(), x, k
For x = 2 To 10
Select Case Range("a" & x)
Case "B"
k = k + 1
ReDim Preserve arr1(1 To k)
arr1(k) = Range("b" & x)
End Select
Next
End Sub
或
Sub a()
Dim arr1(), x, k
For x = 2 To 10
If Range("a" & x) = "B" Then
k = k + 1
ReDim Preserve arr1(1 To k)
arr1(k) = Range("b" & x)
End If
Next
End Sub
额确实变量怎么多写了一个.但是我不理解 1. 循环for....next 没有对应。怎么理解?包括下面的代码为什么一定得把next y放在前面而不能把next x放在前面?否则也会无效的next控件变量引用?
Sub a()
Dim arr, x, y, temp
arr = Range("a1:a9")
For x = 1 To UBound(arr) - 1
For y = x + 1 To UBound(arr)
If arr(x, 1) > arr(y, 1) Then
temp = arr(x, 1)
arr(x, 1) = arr(y, 1)
arr(y, 1) = temp
End If
Next x
Next y