定义一个普通按钮
Private Sub CommandButton1_Click()
ThisWorkbook.Sheets(1).Rows(1).Delete
End Sub
删除指定行,下面的纪录向上移
Sub Macro1()
Rows("11:11").Select
Selection.Delete Shift:=xlUp
End Sub
定义一个普通按钮
Private Sub CommandButton1_Click()
ThisWorkbook.Sheets(1).Rows(1).Delete
End Sub
删除指定行,下面的纪录向上移
Sub Macro1()
Rows("11:11").Select
Selection.Delete Shift:=xlUp
End Sub