[發問] 請問 for 迴圈是那裡錯，要執行二次才能得到資眼，謝謝

wufonna

Sub test()
With Sheets("aa")
For i = 2 To .Range("A" & .Rows.Count).End(xlUp).Row
For Each v In .Cells(i, 7).Resize(, 8)
If v.Text = "" Then .Rows(i).Delete: Exit For
Next
Next
End With
End Sub
請問大大  for 迴圈是那裡錯，要執行二次才能得到資眼，謝謝

GBKEE

回復 1# wufonna
刪除要由下往上

1. Sub test()
   
2.     Dim Rng As Range
   
3.     With Sheets("aa")
   
4.         For i = .Range("A" & .Rows.Count).End(xlUp).Row To 2 Step -1
   
5.             For Each V In .Cells(i, 7).Resize(, 8)
   
6.                 If V.Text = "" Then .Rows(i).Delete: Exit For
   
7.             Next
   
8.         Next
   
9.     End With
   
10. End Sub

複製代碼

wufonna

謝謝 G大
^_^