Private Sub Worksheet_Change(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r > 1 And r < 19 And c = 1 Then r = IIf(r = 18, 2, r + 1)
Cells(r, c).Activate
End Sub 2.rar(12.32 KB, 下载次数: 9)
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r > 1 And r < 19 And c = 1 Then r = IIf(r = 18, 2, r + 1)
Cells(r, c).Activate
End Sub 2.rar(12.32 KB, 下载次数: 9)