How do I create an array?

[JCScoobyRS]

I have the need to create an array for value between A62 and A2136. I need some help as I have never done this before. Any ideas? Thanks, Jeremy

 

[Jay Petrulis]

Hi,

I am not sure I fully understand your request.<pre>Dim x
x = Range("A62:A2136").Value</pre>

will write the range into a two-dimensional array

x(rows,columns) = x(rows,1) here.

_________________
Bye,
Jay

EDIT: For a one dimensional array you can use<pre>x = WorksheetFunction.Transpose(Range("A62:A2136"))</pre>

If the data is in a row rather than a column, do not do the transpose. Multiple rows *and* columns likely need the first method above.
This message was edited by Jay Petrulis on 2002-09-27 16:47

 

[Yogi Anand]

Hi JCScoobyRS:

Jay may have really answered your question. I just wanted to show via the following simulation on how data in cells A62:A67 can be written as an array

y020927.xls
	A	B	C	D	E	F
56
57						sourcedata
58						writtenasanarray
59						arrayexpanded(withCTRL+ENTER)
60
61
62	3		3		3
63	2				2
64	5				5
65	7				7
66	1				1
67	6				6
Sheet7

</SPAN>

Regards!

Yogi
This message was edited by Yogi Anand on 2002-09-27 20:38