How about...
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
' Active Range B8 to G25
If Not Intersect(Target, Range($B$8:$G$25) Then Exit Sub
If Len(Target.Value) = 2 Then
Select Case Target.Column
Case 2 To 6
Target.Offset(0, 1).Select
Case 7
If Target.Row = 25 Then
Range("B8").Select
Else
Target.Offset(1, -5).Select
End If
End Select
End If
End Sub
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion