Selecting non intersect

D

Daniel Gash-Jones

Joined
Nov 5, 2007
Messages
18
Reaction score
0
In VBA how do I select the non-intersected part of two ranges?

ie: if range 1 is A1: D4 and range 2 is A3:F6 the intersect would be A3: D4. I want to select the range A1: D2,A5:F6.

I know I could do this with a loop but surely there must be a more efficient way?
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop by Group Within Group 6
intersect question 12
Application.Intersect 4
Deleting specific information 3
Recorded macro selection widened 4
Select non empty cells 2
File Name changes with dates and Deleting Rows of Zeros 0
Non-Intersect Function 6

Top