|
- Sub Macro1()
- Dim wb As Workbook, date1#, date2#, arr, i&, s&, j%
- Application.ScreenUpdating = False
- Range("a4").CurrentRegion.ClearContents
- date1 = Range("c1"): date2 = Range("c2"): s = 1
- Set wb = GetObject(ThisWorkbook.Path & "\数据DATA.xls")
- arr = wb.Sheets(1).Range("b3").CurrentRegion
- wb.Close 0
- For i = 2 To UBound(arr)
- If arr(i, 1) >= date1 And arr(i, 1) <= date2 Then
- s = s + 1
- For j = 1 To UBound(arr, 2)
- arr(s, j) = arr(i, j)
- Next
- End If
- Next
- If s > 1 Then Range("a4").Resize(s, UBound(arr, 2)) = arr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|