how can you auto return from columns B1 to A2
 

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.

how can you auto return from columns B1 to A2
 

If you select all of columns A:B, then use the tab key, does that help?

arran tw wrote:

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.


--

Dave Peterson

how can you auto return from columns B1 to A2
 

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.

how can you auto return from columns B1 to A2
 

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.

how can you auto return from columns B1 to A2
 

we have been doing it that way but its easy to lose info

"Dave Peterson" wrote:

If you select all of columns A:B, then use the tab key, does that help?

arran tw wrote:

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.


--

Dave Peterson

how can you auto return from columns B1 to A2
 

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.

how can you auto return from columns B1 to A2
 

Arran

Another option not involving code.

Start in column A, enter data then hit TAB to go to column B.

Enter data then hit ENTER key to drop down and back to Column A.




On Wed, 12 Jul 2006 00:30:02 -0700, Stefi
wrote:

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.


Gord Dibben MS Excel MVP