Sub demo()
a = Sheet1.UsedRange
For i = 2 To UBound(a)
For j = 3 To UBound(a, 2)
s = Left(a(i, j), 1)
If s > 0 And s <> "略" Then
a(i, j) = s & (i - 2) Mod 3 + 1
End If
Next
Next
[a1].Resize(UBound(a), UBound(a, 2)) = a
End Sub
Sub demo()
a = Sheet1.UsedRange
For i = 2 To UBound(a)
For j = 3 To UBound(a, 2)
s = Left(a(i, j), 1)
If s > 0 And s <> "略" Then
a(i, j) = s & (i - 2) Mod 3 + 1
End If
Next
Next
[a1].Resize(UBound(a), UBound(a, 2)) = a
End Sub
Sub demo()
a = Sheet1.UsedRange
For i = 1 To UBound(a)
For j = 3 To UBound(a, 2)
s = Left(a(i, j), 1)
If s > 0 And s <> "略" Then
a(i, j) = s & (i - 1) Mod 3 + 1
End If
Next
Next
[a1].Resize(UBound(a), UBound(a, 2)) = a
End Sub