Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Intersecting Ranges 1

Status
Not open for further replies.
logius

logius

Programmer
Aug 30, 2001
175
US
Hey, guys. Anyone know of a way to check if two named ranges intersect? I could run a cell-by-cell check, but I'm looking for a more efficient approach. Any ideas?
 
Sort by date Sort by votes

Dear logius,

try the intersect method of the application object.
(Found in online help after searching for intersect) LOL


Set isect = Application.Intersect(Range("rg1"), Range("rg2"))
If isect Is Nothing Then
MsgBox "Ranges do not intersect"
Else
isect.Select
End If

regards Astrid
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kjv1611
  • Locked
  • Question
Excel Ranges in VBA: Reference same row of NamedRange2 based on current location within NamedRange1 1
Replies
4
Views
82
kjv1611
kjv1611
EDGE99
  • Locked
  • Question
Creating Named Ranges via VBA Issue
Replies
2
Views
32
zelgar
zelgar
JasonEnsor
  • Locked
  • Question
Another bit of tidying up of Excel code, Looping through Ranges J - Q 2
Replies
3
Views
36
JasonEnsor
JasonEnsor
davedave24
  • Locked
  • Question
XL - Ranges from multiple sheets into 1 listbox (or better method?)
Replies
3
Views
30
SkipVought
S
knifey
  • Locked
  • Question
VBA Forecast using variable ranges??? 1
Replies
2
Views
51
combo
combo

Part and Inventory Search

Sponsor

Back
Top