Sub 按钮1_Click()
Dim A(), B(), i&, s&
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
If A(i, 1) = "笔" Then
s = s + 1
ReDim Preserve B(1 To s)
B(s) = A(i, 2)
End If
Next i
End Sub
因为不知道会受什么影响,只好就这样了
Sub 按钮1_Click()
Dim A(), B(), i&, s&
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
If A(i, 1) = "笔" Then
s = s + 1
ReDim Preserve B(1 To s)
B(s) = A(i, 2)
End If
Next i
End Sub
因为不知道会受什么影响,只好就这样了