Sub dq()
x = Range("b65536").End(xlUp).Row
For i = 3 To x
If Cells(i, 2) > Now And Cells(i, 4) = "定报" Then
r = i
Exit For
End If
Next i
Range("b" & r).Select
End Sub
Sub dq()
x = Range("b65536").End(xlUp).Row
For i = 3 To x
If Cells(i, 2) > Now And Cells(i, 4) = "定报" Then
r = i
Exit For
End If
Next i
Range("b" & r).Select
End Sub