Sub My_Del_Rows()
Dim Row_Range As Integer
Row_Range = ActiveSheet.UsedRange.Rows.Count
For i = Row_Range To 1 Step -1
If Application.WorksheetFunction.CountBlank(Rows(i)) = 0 Then
Rows(i).Delete
End If
Next
End Sub
做个循环试试看,比如
with application
i=0
do until i>10000
str_line=""
for j=1 to max_col
str_line=str_line & .cells(i,j)
next
if str_line=""
'del this line
else
i=i+1
end if
loop
end with