Creating Contigous Range from two ranges

E

ExcelMonkey

I have two ranges:
$A$1 and $A$10

How do I bring them together to become a contiguous range. Union will create:

A1, A10

I want A1:A10.

Thanks

EM
 
E

ExcelMonkey

Yeah thats it. I got my wires crossed and assumed it was more difficult than
that.

Thanks

EM
 

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

Naming non-contigent cells with vba 5
Arrays and scattered cell values or another way? 16
Copy Array to Array, how to and should I? 13
Resize range of non-contiguous cells 7
range names 4
Search an array of sheets for an array of numbers & return count of numbers 11
Finding the right style field in VBA 0
setting one worksheet cell range reference to another worksheet 1

Top