|
发表于 2021-11-28 13:26
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton1_Click()
- Dim n&, i&, j&, arr, arrRst
- arr = Sheets("2").[a1].CurrentRegion
- ReDim arrRst(1 To UBound(arr), 1 To 12)
- For i = 2 To UBound(arr)
- If ComboBox1 = arr(i, 4) Then
- n = n + 1
- arrRst(n, 1) = arr(i, 1)
- For j = 5 To 15
- arrRst(n, j - 3) = arr(i, j)
- Next j
- End If
- Next i
- Sheets(CStr(4 + (Val(ComboBox1) <= 10))).[a2].Resize(n, 12) = arrRst
- End Sub
复制代码 |
|