Thanks Mike, it worked but I have no idea why.

If I were to use this same formula in another worksheet, what section of the
below formula would I change to tell excel to wrap at column K or Z?

"Mike H" wrote:

Try this:-

Right click the sheet tab , view code anf paste this in:-

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Column 14 Then
Cells(ActiveCell.Row + 1, 1).Select
End If
End Sub

Mike

"nabanco" wrote:

Hello,

Is there a way to prevent tabbing past a certain point in a spreadsheet?

For example, if my sheet goes from column A to column N, can I block all
cursur movement beyond column N? I am trying to get it to automatically wrap
back to column A when column N is reached.

Thank you