Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Combine Ranges

Posted on 2010-11-19
4
Medium Priority
?
336 Views
Last Modified: 2012-08-14
I'm trying to combine two named ranges in VB.  MyRange1 and MyRange2 as MyRange.

I think i need something like: Union(MyRange1, MyRange2)
0
Comment
Question by:mgmee
4 Comments
 
LVL 24

Accepted Solution

by:
Tracy earned 252 total points
ID: 34174070
Try this:

Set myRange = Application.Union(Range("MyRange1"), Range("MyRange2"))
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 248 total points
ID: 34174073
Yup
Set MyRange = Union([MyRange1], [MyRange2])
0
 
LVL 50
ID: 34608828
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question