No matter what i do i keep getting runtime error 1004.
I get the error on the below line:
I tries Cells and Range and also sheets(), but still get the error on that line.
I replaced row and column referances with fixed numbers but still get the error.
Code:
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" Then
dual_both.Show
End If
Range("M" & i_row).Select
ActiveCell.Interior.ColorIndex = 2
End If
I get the error on the below line:
Code:
ActiveCell.Interior.ColorIndex = 2
I tries Cells and Range and also sheets(), but still get the error on that line.
I replaced row and column referances with fixed numbers but still get the error.