Hi Arran,

Press Alt-F11 (launches VB window)
Right Click on your worksheet in the Project window
Choose View code from the local menu
Copy and Paste there the Sub

Regards,
Stefi


€žarran tw€� ezt Ã*rta:

please could you let me know how to install thanks.

"Stefi" wrote:

Install this Change event sub:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Range("A" & Target.Row + 1).Select
End If
End Sub

It will return to column A in the next line after filling cells in column B.
Please post if you need help to install it!

Regards,
Stefi

€žarran tw€� ezt Ã*rta:

lets say you r using just 2 columns A and B all i want to do is return to the
start of the next line which would be a2 and so, oh if you highlight both
columns it will return to the next line can you do it with out hightlighting.