选取任意一行或连续多行,复制数据后删除,谢谢! 如:以下是选第2行,我想选取任意一行或连续多行,如何表示? sub ruku() Dim i As Integer i = Sheets("入库").[a65536].End(xlUp).Row + 1 If ActiveCell = "" Then MsgBox "请先选择商品数据记录!" Else Range("a2:e2").Select Selection.Copy Sheets("入库").Cells(i, 1) Range("a2:e2").EntireRow.Delete End If End Sub
sub ruku() Dim i As Integer i = Sheets("入库").[a65536].End(xlUp).Row + 1 If ActiveCell = "" Then MsgBox "请先选择商品数据记录!" Else selection.Copy Sheets("入库").Cells(i, 1) selection.EntireRow.Delete End If End Sub
[此贴子已经被作者于2010-8-21 18:04:29编辑过]
|