Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$I$18" Then
Application.DisplayAlerts = False
[r4:r23].Copy [u4].Offset(0, Target)
Application.DisplayAlerts = True
End If
End Sub 颇有难度的填充问题2.rar(11.99 KB, 下载次数: 5)
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$I$18" Then
Application.DisplayAlerts = False
[r4:r23].Copy [v4].Resize(1, 40) '是复制到整个区域?
Application.DisplayAlerts = True
End If
End Sub