Combine Ranges

I'm trying to combine two named ranges in VB.  MyRange1 and MyRange2 as MyRange.

I think i need something like: Union(MyRange1, MyRange2)
mgmeeAsked:
Who is Participating?
 
TracyConnect With a Mentor VBA DeveloperCommented:
Try this:

Set myRange = Application.Union(Range("MyRange1"), Range("MyRange2"))
0
 
Rory ArchibaldConnect With a Mentor Commented:
Yup
Set MyRange = Union([MyRange1], [MyRange2])
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.