Sub 删除指定列无背景色单元格所在行()
Dim rng As Range
Dim QuYu As Range
Set QuYu = Range("F1:F20") '指定区域
x = QuYu.Cells.Count
For i = x To 1 Step -1
Debug.Print QuYu.Cells(i, 1).Value
If QuYu.Cells(i, 1).Interior.ColorIndex = xlNone Then QuYu.Cells(i, 1).EntireRow.Delete
Next
End Sub
温馨提示:答案为网友推荐,仅供参考