¦U¦ì¾Çªø¦n:
§Ú¦bºô¸ô¤W¦¬´M¨ì¤@¬qµ{¦¡¡AÁöµM«Ü¦n¥Î
¦ý¨C¤é¸ê®Æ®w¦³¤W¸Uµ§¸ê®Æ¡A³y¦¨¨C¤@¶µÀˬd+§R°£ªá¤F«Ü¤[®É¶¡
¦³¿ìªk¦b²¤ÆÀˬdªº®É¶¡¶Ü?¹wp¶}¤u¤é¤w¦³¨Ì·Ó®É¶¡±Æ§Ç
Set sh1 = Sheets(1) '§R°£¶}¤u¤é¶W¹L¤µ¤Ñ
f = sh1.Columns("A:L").Find("*", LookIn:=xlValues, SearchDirection:=xlPrevious).Row
On Error Resume Next
dn = Date + 1
For i = f To 2 Step -1
If IsError(sh1.Cells(i, "L")) = False Or sh1.Cells(i, "L") <> "" Then
dv2 = sh1.Cells(i, "K")
y2 = Format(Left(dv2, 4), "0000")
m2 = Format(Mid(dv2, 5, 2), "00")
d2 = Format(Mid(dv2, 7, 2), "00")
dv2 = DateValue(Format(y2 & "/" & m2 & "/" & d2, "yyyy/mm/dd"))
If dv2 > dn Then
sh1.Rows(i).Delete Shift:=xlUp
End If
End If
Next |