|
楼主 |
发表于 2016-11-1 13:00
|
显示全部楼层
公式顺序调整后达到预期效果,感谢 蓝桥玄霜 老师!
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Application.EnableEvents = False
k = Range("C6556").End(xlUp).Row
Cells(4, 2).Copy Range(Cells(4, 2), Cells(k, 2)) '第2列第4行开始
If Target.Count > 1 Then Exit Sub
If Target.Column = 3 Or Target.Row > 3 Then
If Target = "" Then Target.Offset(0, -1) = ""
Else
End If
Application.EnableEvents = True
Application.ScreenUpdating = T
End Sub
|
|