Sub 以单元格数字制指定范围复制删除()
Z = Range("b6") '行数
Range("A10:l10").Copy Range("A11:l" & 10 + Z) '复制区域
With ActiveSheet
.Range(.Cells(11 + Z, 1), .Cells(65536, 12)).Clear
End With
End Sub
Sub 以单元格数字制指定范围复制删除()
Z = Range("b6") '行数
Range("A10:l10").Copy Range("A11:l" & 10 + Z) '复制区域
With ActiveSheet
.Range(.Cells(11 + Z, 1), .Cells(65536, 12)).Clear
End With
End Sub