no. if you want to test if the target falls in a range

if not intersect(Target, Range("N" & j & ":Q" & j)) then


--
Regards,
Tom Ogilvy



"CRayF" wrote in message
...
This works:
If Target.Address = "$N$" & j Or _
Target.Address = "$O$" & j Or _
Target.Address = "$P$" & j Or _
Target.Address = "$Q$" & j Then

Wouldn't this work (or do I jsut have the syntax down wrong)?
If Target.Address = "$N$" & j & ":$Q$" & j Then