intersect tells you whether two ranges have any cells in common-it returns either the common range or nothing. if you changed b4 then intersect(target, Range("b4")) would not be nothing