|
Sub e()
Dim rn As Range, rns As Range
On Error GoTo 100
Select Case Weekday(Now, 2)
Case Is = 1 '周一
If Time < CDate("15:00:00") Then
For Each rn In Range("a2:a" & Cells(Rows.Count, "a").End(3).Row)
y = rn.Value
If Date - 2 < rn.Value < Date Then
n = n + 1
If n = 1 Then
Set rns = rn.EntireRow.Range("a1:e1")
Else
Set rns = Union(rns, rn.EntireRow.Range("a1:e1"))
End If
rns.Delete
End If
Next
Else
For Each rn In Range("a2:a" & Cells(Rows.Count, "a").End(3).Row)
If rn.Value <> Date + 1 Then
n = n + 1
If n = 1 Then
Set rns = rn.EntireRow.Range("a1:e1")
Else
Set rns = Union(rns, rn.EntireRow.Range("a1:e1"))
End If
End If
Next
rns.Delete
End If
'周六
Case Is = 6
For Each rn In Range("a2:a" & Cells(Rows.Count, "a").End(3).Row)
If rn <> Date + 1 And rn <> Date Then
n = n + 1
If n = 1 Then
Set rns = rn.EntireRow.Range("a1:e1")
Else
Set rns = Union(rns, rn.EntireRow.Range("a1:e1"))
End If
End If
Next
rns.Delete
'周日
Case Is = 7
For Each rn In Range("a2:a" & Cells(Rows.Count, "a").End(3).Row)
If rn <> Date + 1 And rn <> Date And rn <> Date Then
n = n + 1
If n = 1 Then
Set rns = rn.EntireRow.Range("a1:e1")
Else
Set rns = Union(rns, rn.EntireRow.Range("a1:e1"))
End If
End If
Next
rns.Delete
'周2-5
Case Is > 1
If Time < CDate("15:00:00") Then
For Each rn In Range("a2:a" & Cells(Rows.Count, "a").End(3).Row)
If rn.Value <> Date Then
n = n + 1
If n = 1 Then
Set rns = rn.EntireRow.Range("a1:e1")
Else
Set rns = Union(rns, rn.EntireRow.Range("a1:e1"))
End If
End If
Next
rns.Delete
Else
For Each rn In Range("a2:a" & Cells(Rows.Count, "a").End(3).Row)
If rn.Value <> Date + 1 Then
n = n + 1
If n = 1 Then
Set rns = rn.EntireRow.Range("a1:e1")
Else
Set rns = Union(rns, rn.EntireRow.Range("a1:e1"))
End If
End If
Next
rns.Delete
End If
End Select
100
End Sub
把这个放进去了对了 |
|