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