|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下。。。- Sub ykcbf() '//2024.1.1
- Dim arr, brr
- Application.ScreenUpdating = False
- With Sheets("数据源")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .[a1].Resize(r, 3)
- rq1 = .[h1]
- rq2 = .[i1]
- End With
- ReDim brr(1 To UBound(arr), 1 To 3)
- m = 1
- brr(m, 1) = arr(1, 1)
- brr(m, 2) = arr(1, 2)
- brr(m, 3) = arr(1, 3)
- For i = 2 To UBound(arr)
- s = Val(arr(i, 1))
- If s >= rq1 And s <= rq2 Then
- m = m + 1
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- End If
- Next
- With Sheets("提取数据")
- .Cells.Clear
- With .[a1].Resize(m, 3)
- .Value = brr
- .Borders.LineStyle = 1
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
|