Tab Button

T

Tami

I've created a spreadsheet and have hidden the cells that I don't intend on
using. When I use the tab button, it will advance along a row until it
reaches the end of the columns I have showing, but what I want to know is how
to get the tab button to advance it to the beginning of the next row when it
comes to the end. Is there a way to do this?
 
B

Bill Kuunders

one way

enter in the worksheet code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Offset.Column = 8 Then Selection.Offset(1, -7).Select
End Sub

Of course you will have to determine the column number and how far to the
left .
Greetings from New Zealand
Bill K
 
Top