Worksheet_SelectionChange script errors for unknown reason

[addylad92]

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.

Please Login or Register  to view this content.

Any ideas?

Thanks.

[Palmetto]

I would use the Intersect Method

Please Login or Register  to view this content.

Adjust the range reference to suit - it could be made dynamic so that additional rows are accounted for you expect data beyond row 100.

[OllieB]

I would use:

Please Login or Register  to view this content.