Target is a Range, comparing it with a the string "E10" only results FALSE ottype mismatch, therefore it must be:If Target = Range("E10") Then