[µo°Ý] ½Ð°Ý for °j°é¬O¨º¸Ì¿ù¡A­n°õ¦æ¤G¦¸¤~¯à±o¨ì¸ê²´¡AÁÂÁÂ

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
½Ð°Ý¤j¤j  for °j°é¬O¨º¸Ì¿ù¡A­n°õ¦æ¤G¦¸¤~¯à±o¨ì¸ê²´¡AÁÂÁÂ

GBKEE

¦^´_ 1# wufonna
§R°£­n¥Ñ¤U©¹¤W

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

½Æ»s¥N½X

wufonna

ÁÂÁÂ G¤j
^_^