Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
For i = 2 To Range("a65536").End(3).Row
Cells(i, 2) = i - 1
Next
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
For i = 2 To Range("a65536").End(3).Row
Cells(i, 2) = i - 1
Next
End If
End Sub