Bob Phillips wrote

You're not looking are you? The answer is already in the code, use

If Intersect(Target, Range("C5:C35")) Is Nothing Then Target.Offset(0,
2).Select


Well, if it were that obvious, I would have used it. Problem is I only want
that to happen (Target.Offset(0,2).Select) if I enter something in C5:C35.
Your offering moves 2 cols over no matter where I enter something.

--
David