来自http://tunps.com/excel-vba-macro-delete-specified-line-and-last-line
有时候从网页表格中复制进excel里面，会有多余的表头信息和表尾信息，删除表头/表尾行的宏可以这么写：
Sub DeleteHeadAndTail() 'delete line 1,2,3 ActiveSheet.Range("1:1,2:2,3:3").Delete 'delete last line Range("a65536").End(xlUp).Select Selection.EntireRow.DeleteEnd Sub |
