- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Column = 2 Then '如果A1单元格有变化,则
- Application.ScreenUpdating = False
- Dim s As Shape, x As Range
- For Each s In Sheet1.Shapes
- If s.Type = 13 Then s.Delete
- Next s
- For Each x In Sheet1.Range("B2", [B1048576].End(3))
- If Not Sheet2.[B:B].Find(x, , , 1) Is Nothing Then
- Sheet2.[B:B].Find(x, , , 1).Offset(, 1).Copy x.Offset(, 1)
- Sheet2.[B:B].Find(x, , , 1).Offset(, 2).Copy x.Offset(, 2)
- Sheet2.[B:B].Find(x, , , 1).Offset(, 3).Copy x.Offset(, 3)
- Sheet2.[B:B].Find(x, , , 1).Offset(, 4).Copy x.Offset(, 4)
- Sheet2.[B:B].Find(x, , , 1).Offset(, 5).Copy x.Offset(, 5)
- Sheet2.[B:B].Find(x, , , 1).Offset(, 6).Copy x.Offset(, 6)
- Sheet2.[B:B].Find(x, , , 1).Offset(, 7).Copy x.Offset(, 7)
- End If
- Next x
- Application.ScreenUpdating = True
- End If
- End Sub
复制代码
老师这个是哪里错了呢 |