Private Sub Worksheet_Change(ByVal Target As Range)
Dim a, b, c
If (Target.Column = 2 And Target.Row >= 2 And Target.Row <= 900) Or (Target.Column > 2 And Target.Column <= 8 And Target.Row >= 3 And Target.Row <= 100) Or (Target.Column = 9 And Target.Row >= 10 And Target.Row <= 20) Then
a = Target.Value
b = Left(a, 2)
c = Right(a, 2)
If b <> "测试" And c <> "数据" Then Target = "测试" & a & "数据"
Private Sub Worksheet_Change(ByVal Target As Range)
Dim a, b, c
If (Target.Column = 2 And Target.Row >= 2 And Target.Row <= 900) Or (Target.Column > 2 And Target.Column <= 8 And Target.Row >= 3 And Target.Row <= 100) Or (Target.Column = 9 And Target.Row >= 10 And Target.Row <= 20) Then
a = Target.Value
b = Left(a, 2)
c = Right(a, 2)
If b <> "测试" And c <> "数据" Then Target = "测试" & a & "数据"