Hard Return

[Michael Koerner]

Currently have Excel set, so that whenever I press Enter I go to the next cell to the right. Is there a way to set it up so that when you reach the end of a data range i.e column G for example, that when you hit enter you return to Column A in the next Row. Like a Hard Return.

 

[Simon Lloyd]

Currently have Excel set, so that whenever I press Enter I go to the
next cell to the right. Is there a way to set it up so that when you
reach the end of a data range i.e column G for example, that when you
hit enter you return to Column A in the next Row. Like a Hard Return.

in TOOLS>OPTIONS>EDIT, then right click your worksheet tab and choose
VIEW CODE and paste this in:

Code:
--------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 8 Then Exit Sub
If Target.Column = 8 Then
Target.Offset(1, -7).Select
End If
End Sub
--------------------


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Otto Moehrbach]

Michael

Put this little macro in the sheet module of your sheet. To access that module, right-click on the sheet tab, select View Code. Paste this macro into that module. "X" out of the module to return to your sheet. This macro will select the cell in the next row in Column A if any change occurs to the contents of any cell in Column G (column # 7). HTH Otto

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Then Exit Sub

If Target.Column = 7 Then

Cells(Target.Row + 1, 1).Select

End If

End Sub

Currently have Excel set, so that whenever I press Enter I go to the next cell to the right. Is there a way to set it up so that when you reach the end of a data range i.e column G for example, that when you hit enter you return to Column A in the next Row. Like a Hard Return.

 

[Michael Koerner]

Thanks to all, works just great.

--

Regards
Michael Koerner


Currently have Excel set, so that whenever I press Enter I go to the next
cell to the right. Is there a way to set it up so that when you reach the
end of a data range i.e column G for example, that when you hit enter you
return to Column A in the next Row. Like a Hard Return.