|
发表于 2012-12-16 15:39
|
显示全部楼层
本楼为最佳答案
- Private Sub Worksheet_Change(ByVal Target As Range)
- Application.EnableEvents = False
- If Target.Count = 1 And Target.Column = 1 Then
- If Target <> "" And Target.Row = Cells.Find("*", , , , 1, 2).Row - 1 Then
- Rows(Target.Row).Insert
- Target.EntireRow.Copy Target.Offset(-1, 0)
- Target.EntireRow.ClearContents
- End If
- End If
- Application.EnableEvents = True
- End Sub
复制代码 |
评分
-
查看全部评分
|