Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Selection.AutoFill Destination:=Selection.Resize(Val(Left(Selection, 2)))
End If
End Sub
单独一列现在没有问题了,谢谢。 现在我把B列改成这样可行吗?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Application.EnableEvents = False
Select Case Target.Text
Case Is = Val(Left(Target.Value, 2))
Range("B" & Target.Row) = Selection
Application.EnableEvents = True
End Select
End If
End