Return to Cell in Column A after entering value in Column Z

Hi,

I've been struggling with coming up with VBA code so that anytime a value is entered in column Z that the cursor returns to column A one row below where the entry was in Z.

Example : Cell Z5 Value = 1.5

After entering that value it then returns to cell A6.

Does anyone have any ideas if this is possible & how to do it?

Thanks!

Put this in the worksheet code module for the affected sheet

Code:

---

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    With Target.Cells(1, 1)
        If .Column <> 26 Then Exit Sub
        Application.Goto .Offset(1, -25), False
    End With
End Sub

---

Quote:

---

Originally Posted by Paul_Hossler

Put this in the worksheet code module for the affected sheet

Code:

---

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    With Target.Cells(1, 1)
        If .Column <> 26 Then Exit Sub
        Application.Goto .Offset(1, -25), False
    End With
End Sub

---

---

Excellent. I was using an activecell formula similar but it wasn't working. This is perfect. Thanks for the help!