array to range

[Corticus]

Wassup fellow Excelers,

I would like to take a single dimension array and display the values down a range of cells. Can I do this?

In this example, I create a 6 element array from the range("A1:A6").

Then I do some array manipulation (like quicksort).

Now I want to return the array to a range of cells.

Kind of like this, but without the error:

Book2
	A	B	C	D
1	F	#NAME?
2	E	#NAME?
3	D	#NAME?
4	C	#NAME?
5	B	#NAME?
6	A	#NAME?
Sheet1

In this case, I would want to use the formula just like I did, but [B1] would display the array(1), [B2] would display array(2) etc.

Thanks in advance for any help!

 

[NateO]

Performance is kind of a mut point though, I just wanted to get the array on a range, and it looks like we got it!

Thanks for all your help Nate, even on my odd useless questions...

If it's moot, glad I didn't test it!

You're welcome!