Hi there

My VBA code is giving me trouble (Excel 2010). This is supposed to trigger another macro (using Worksheet_SelectionChange) if the cell selected is in column 10 and row 5 onwards, and contains particular text. The script works fine normally, but in U5, where it should not do anything, this code shows up in yellow.

If Target(1, 1).Column = 10 And Target(1, 1).Row > 4 And Target(1, 1).Value = "McMillan" Then
Any ideas?

Thanks.