f = Sheet1.[A65536].End(xlDown).Row z = Sheet2.[A65536].End(xlDown).Row 或者 f = Sheet1.cells(rows.count,a).End(xlDown).Row z = Sheet2.cells(rows.count,a).End(xlDown).Row