|
在你原来的worksheet_Change事件下加了一小段- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim r
- If Target.Address = "$D$1" Then
- If [a:a].Find(Target, , , 1) Is Nothing Then
- [a65536].End(3).Offset(1).Select
- Else
- r = [a:a].Find(Target, , , 1, , 2).Row
- Rows(r + 1).EntireRow.Insert
- Cells(r, 1).Resize(1, 2).Copy Cells(r + 1, 1)
- Cells(r + 1, "g") = Cells(r, "g") + Cells(r + 1, "e")
- End If
- ElseIf Target.Column = 7 And Target.Row >= 3 Then
- arr = Range("a1:k" & [a65536].End(3).Row)
- For i = 3 To UBound(arr)
- If arr(i, 10) = "" Then arr(i, 10) = arr(i - 1, 10)
- Next
- i = Target.Row
- Cells(i, 11) = IIf(arr(i, 10) >= arr(i, 7), "否", "是")
- End If
- End Sub
复制代码 |
|