Not sure if this helps but try using the intersect function to test if a cell is within a range.

if intersect(range1, range2) is nothing then

'if it does not intersect

else

'if it does intersect

end if