¤@¯ë¼Ò²Õ:
Option Explicit
Sub TEST()
Dim Y%, R%, xR As Range
Set xR = [A1]
Do Until R >= 101
Y = Y + 1
R = Y * 5 + 1
xR(R) = Val(xR) + 10 * Y
Loop
End Sub
¤u§@ªí¼Ò²Õ:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then Call TEST
End Sub