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)
Who is Participating?
TracyConnect With a Mentor VBA DeveloperCommented:
Try this:

Set myRange = Application.Union(Range("MyRange1"), Range("MyRange2"))
Rory ArchibaldConnect With a Mentor Commented:
Set MyRange = Union([MyRange1], [MyRange2])
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.
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.