Working with arrays 2

[rgandy]

How can I place a range into an array
ie.
TestArray = range("TestRange")
where test range is the range ("a1:z20")

and then grab the first row of data with one line of code?

ie. grab the contents of ("a1:z1") for manipulation

(for this particular example i want to take this data and output it to a range)

thanks!

 

[Zathras]

To answer your qustion, you can use a variant like this:

Sub test()
Dim TestArray
  TestArray = Range("A1:Z20")
  MsgBox TestArray(2, 2)
End Sub

But to accomplish what you want to do, don't use an array, use ranges like this:

Sub test2()
Dim r As Range
  Set r = Range("A1:Z20").Rows(1)
  MsgBox r.Address
End Sub

 

[SkipVought]

rgandy,

Just to piggy-back on Zathras' suggestion, take a look at Collections & Objects in the VB Help. There are all kinds of Collections of Objects in Excel.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[rgandy]

great thanks!

 

[rgandy]

THANKS GUYS