Add two Ranges to Array

[JStellato]

Hello, I need to add two ranges to an array. My current code only has one range, I've tried to add a second range, but my attempts have been futile.

Here's my current code:

MyArray = Range([a3], [h30])

I've tried

MyArray = Range([a3], [h30]) & Range([i3], [p30])

and

MyArray = Range([a3], [h30])
MyArray = MyArray + Range([i3], [p30])

none of these are the right answer. Anyone have any ideas?

Thanks!

 

[JStellato]

Excellent, this worked perfectly. I'm really starting to put all this together. Thanks again!

 

[brettdj]

No problem

You may find these two articles I've written on using arrays helpful

Cheers

Dave


Using Variant Arrays in Excel VBA for Large Scale Data Manipulation http://www.experts-exchange.com/A_2684.html
a. Shows how to use variant arrays with ranges to quickly manipulate data
b. Caters for ranges that may contain single cells (which cannot be used in variant arrays)
c. This sample code removes all leading zero’s from each cell in a user selection
Creating and Writing to a CSV File Using Excel VBA Article http://www.experts-exchange.com/A_3509.html
a. Shows how to create a CSV File via VBA, a very efficient method of creating reports
b. This sample code transposes rows and columns within a selected range