About Us

-JEFF-[_2_]

Thank You, Doug, works great!
-JEFF-

"Doug Glancy" wrote:

Jeff,

I believe this does it:

Sub test()
Dim test_array()
Dim first_dimension_count As Long
Dim i As Long

first_dimension_count = Range("A" & Rows.Count).End(xlUp).Row
ReDim test_array(1 To first_dimension_count, 1 To 2)
test_array = Range("A1:B" & first_dimension_count)
End Sub

hth,

Doug

"-JEFF-" wrote in message
...
I need to assign dimension 1 with col A data and dimension 2 with col B
data.
IOW, element 1 would consist of A1, B1, element 2 A2, B2... The number of
rows is not always the same. Can somebody provide an example of code to
accomplish this? Thanks! -JEFF-

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign Values to array	Jeff	Excel Discussion (Misc queries)	14	July 15th 08 06:06 PM
Array transfer - 1 dimension v. 2 dimension	JWolf[_2_]	Excel Programming	2	June 29th 04 01:02 AM
Getting excel array dimension	banavas[_3_]	Excel Programming	3	June 8th 04 12:11 PM
How do I assign values to an array?	Skyway[_2_]	Excel Programming	14	February 29th 04 01:22 AM
single dimension array	RobcPettit	Excel Programming	3	January 20th 04 08:33 AM

Menu

About Us