Need to Redefine Range to include Additional Ranges

J

Jamie Carper

Hi,

I need to have a Range expand to include additional ranges.

e.g. Set MyRange = MyRange + YourRange

So that MyRange.Select will select the total area encompassed by the
prior two ranges.

I have tried Append, Join, Merge... these all seem to deal with the
contents of the ranges. Whereas I want to merge the ranges NOT the
cell values.

Any help please,

Jamie
 

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

macro to select a range from a set cell to a specified cell 6
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Text not looping through ranges 10
concatenate dynamic ranges 7
How to get evaluated value of worksheet names that do not refer to worksheet ranges? 1
Excel 2007 - Remove Name Range via Name Manager 1
How to incorporate 2 sets of changing named ranges 2
Array formula: how to join 2 ranges together to form one array? 2

Top