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.

 

[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.