Programmable Column Sequencing?
OssieMac, your code will surely render the workbook inoperable, as each
select statement will trigger the change event, resulting in an infinite loop.
May I offer a modification:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim strCol As String
Static Recursed as Booelan
if recursed then exit sub
recursed = true
'Assign the column Alpha Id to variable
strCol = Split(Columns(Target.Column) _
.Address(, 0), ":")(1)
Select Case strCol
Case "A"
Cells(Target.Row, "D").Select
Case "B"
Cells(Target.Row, "E").Select
Case "C"
Cells(Target.Row, "K").Select
Case "AB"
Cells(Target.Row, "AZ").Select
End Select
recursed = false
End Sub
Best,
|