How to select and delete a range of cells between two different ranges of unequal size?

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

Hello GaidenFocus,

Range1 is dynamic from worksheet to worksheet and the ranges will never intersect. My issue is selecting the range in between.

Thanks for the suggestion though