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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks