No matter what i do i keep getting runtime error 1004.
If Target.Column = zone_Bend ThenIf Cells(i_row, zone_Bend).Value = "A End" Then
dual_a.Show
Sheet17.Select
MsgBox "Hello"
ElseIf Cells(i_row, zone_Bend).Value = "B End" Then
dual_b.Show
ElseIf Cells(i_row, zone_Bend).Value = "Both Ends"...