If I would like to set up 3 columns A, B, & C and would like B to be small
and just to break up columns A & C, is there a way to tab over B when
entering information from A then C?

Thanks,
Heather

Enter the following in worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("A:A"), Target) Is Nothing Then
Exit Sub
End If
Target.Offset(0, 2).Select
End Sub


Whenever data is entered in column A, the active cells moves over to column
C instead of column B.


REMEMBER: worksheet code, not a standard module.
--
Gary''s Student
gsnu200708


"Heather" wrote:

If I would like to set up 3 columns A, B, & C and would like B to be small
and just to break up columns A & C, is there a way to tab over B when
entering information from A then C?

Thanks,
Heather