如题所述
è¯å¥ï¼
Range(Range("a1").End(xlDown).Offset(1), Range("a65536")).EntireRow.Delete
å®æ´æµè¯éªè¯æ 误ç代ç ï¼
Sub xxx()Range(Range("a1").End(xlDown).Offset(1), Range("a65536")).EntireRow.Delete
End Sub
温馨提示:答案为网友推荐,仅供参考
第1个回答 2014-11-27
sub aaa()
range(range("a1").end(xldown).offset(1,0),cells(rows.count,1)).entirerow.delete
end sub
range(range("a1").end(xldown).offset(1,0),cells(rows.count,1)).entirerow.delete
end sub