本帖最后由 xiangbaoan 于 2019-4-17 19:00 编辑
Option Explicit
Private Sub Worksheet_Change(ByVal t As Range)
On Error Resume Next
If Not Intersect(Range([c2:g2], [c2:g2].End(xlDown)), t) Is Nothing Then
Dim ar, r&, i&, j%, c%, k&
ar = Range([c2:g2], [c2:g2].End(xlDown))
ReDim br%(1 To 20, 1 To 11)
r = UBound(ar)
For i = IIf(r > 20, r - 19, 1) To IIf(r > 20, r, UBound(ar))
k = k + 1
For j = 1 To 5
br(k, ar(i, j)) = ar(i, j)
Next
Next
If k Then
[l2].Resize(20, 22) = ""
[l2].Resize(k, 11) = br
[w2].Resize(k, 11) = br
End If
End If
End Sub
|