Sub q() Dim arr, i%, Erow%, s, k% s = Month(Range("G3").Value) & Day(Range("G3").Value) k = 1 With Sheets("资料库") Erow = .[D65536].End(3).Row arr = .Range("A4:AK" & Erow) End With For i = 1 To UBound(arr) If Month(arr(i, 33)) & Day(arr(i, 33)) = s Then k = k + 1 Cells(k, 1) = arr(i, 2) Cells(k, 2) = arr(i, 4) Cells(k, 3) = arr(i, 33) End If Next End Sub
Sub q() Dim arr, i%, Erow%, s, k% s = Month(Range("G3").Value) & Day(Range("G3").Value) k = 1 With Sheets("资料库") Erow = .[D65536].End(3).Row arr = .Range("A4:AK" & Erow) End With For i = 1 To UBound(arr) If Month(arr(i, 33)) & Day(arr(i, 33)) = s Then k = k + 1 Cells(k, 1) = arr(i, 2) Cells(k, 2) = arr(i, 4) Cells(k, 3) = arr(i, 33) End If Next End Sub