Combine ranges and create array

Hi,

how can i merge 2 ranges and create one array from them in fastest way?

Best wishes for you,
Jacek Antek

The following code puts A1:A10 and D1:D10 into a 1-dimensional array;

Please Login or Register  to view this content.

.

Hi thank you.

I think that it is a good approach,

Best,
Jacek