Creating an array from non-contiguous ranges

D

David

Is there an efficient way of creating a multidimensional
array from non-contiguous ranges?

The following only works because the ranges are contiguous:

Dim vaData As Variant
vaData = Range("A17:R18","A19:R20").Value
 

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

Range to an Array doesn't contain values 6
need a robust transpose(array) function 1
1d Variant arrays? 3
Array keeps returning Null Values 2
Print Non-Contiguous Ranges From User Input on All Worksheets 4
loading multiple non-contiguous range into an array 2
Help - Update a SQL table from a specific range in Excel 2
Non contiguous ranges 4

Top