请问为何 Delete 的部分会不对 ???(Delete “空” 时)
Dim D As Variant
For D = 7 To [R65536].End(xlUp).Row
If Cells(D, "R") = "" Then Rows(D).Delete shift:=xlShiftUp
If Cells(D, "CT") = 0 Then Rows(D).Delete shift:=xlShiftUp
If Cells(D, "CU") <> "" Then Cells(D, "CU").ClearContents
Next
Dim D As Variant For D = 3000 To 7 Step -1
If Cells(D, "R") = "" Then Rows(D).Delete shift:=xlShiftUp
If Cells(D, "CT") = 0 Then Rows(D).Delete shift:=xlShiftUp
If Cells(D, "CU") <> "" Then Cells(D, "CU").ClearContents
Next