|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
这样试试
Private Sub CommandButton15_Click()
Dim r&, ar, br, cr, i&, j&, k&, m&, n&, s$, y&
n = Val(ComboBox2.Value)
If n = 0 Then Unload UserForm1: Exit Sub
With Sheets("Sheet2")
br = .[a5].CurrentRegion.Value
End With
ReDim cr(1 To UBound(br), 1 To UBound(br, 2))
For i = 1 To UBound(br)
m = Val(br(i, 6))
If m = n Then
k = k + 1
For j = 1 To UBound(br, 2)
cr(k, j) = br(i, j)
Next
End If
Next
With Sheets("Sheet3")
If k > 0 Then .[a65536].End(xlUp).Offset(1).Resize(k, UBound(cr, 2)) = cr
End With
Unload UserForm1
End Sub
|
评分
-
2
查看全部评分
-
|