|
楼主 |
发表于 2013-12-6 14:16
|
显示全部楼层
zhp3 发表于 2013-12-6 14:06
公式计算对应的星期,再筛选删除
你好,谢谢能不能实现程序化操作,因为我要删除的表比较多,
下面是我编的一个但老出问题
Sub Test()
Dim A()
Dim i, j, n, y
For j = 1 To Sheets.Count
With Sheets(j).Select
n = Range("a65536").End(xlUp).Row
For i = 1 To n - 2
A(i, 1) = Sheets(j).Range(i + 2, 1).Value
If Application.WorksheetFunction.Weekday(A(i, 1), 2) <> 5 Then A(i, 3) = 1 '标记非星期五
Next i
On Error Resume Next
Application.DisplayAlerts = False
.Range("c:c").SpecialCells(xlCellTypeConstants).EntireRow.Delete
On Error GoTo 0
End With
Next j
End Sub
|
|