Attach the following to the worksheet you are working on...
Assumption: The cursor goes to K7 when you enter something in K6 and press
Enter...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$K$7" Then
Range("K2").Activate
End If
End Sub

"GAME.ON.GFX" wrote:

How do I set a macro to go to a specific cell when my cursor hits a specified
cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want
the cursor to go back to k2.
Thanks.