| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range values in an array?
Is ther an easy way to read the values of multiple cells into an array?
myArray = Range(LeftCell, RightCell) <-? Thanks Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range values in an array?
myArray = Range("A1:Z1")
Or do you mean something else? -- Kind regards, Niek Otten "Mike" wrote in message ... Is ther an easy way to read the values of multiple cells into an array? myArray = Range(LeftCell, RightCell) <-? Thanks Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range values in an array?
I am wanting to put the values from each cell in a range into an array.
Thanks MIke "Niek Otten" wrote: myArray = Range("A1:Z1") Or do you mean something else? -- Kind regards, Niek Otten "Mike" wrote in message ... Is ther an easy way to read the values of multiple cells into an array? myArray = Range(LeftCell, RightCell) <-? Thanks Mike |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range values in an array?
Mike,
Further to Niek's reply (as an illustration): Sub test() Dim myArray As Variant myArray = Range("a1:b20") For r = 1 To UBound(myArray, 1) For c = 1 To UBound(myArray, 2) Debug.Print myArray(r, c) Next Next End Sub HTH "Mike" wrote: I am wanting to put the values from each cell in a range into an array. Thanks MIke "Niek Otten" wrote: myArray = Range("A1:Z1") Or do you mean something else? -- Kind regards, Niek Otten "Mike" wrote in message ... Is ther an easy way to read the values of multiple cells into an array? myArray = Range(LeftCell, RightCell) <-? Thanks Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting values from a variable sized range into an array | Excel Programming | |||
| Array of Values from Worksheet Range - What does it 'look' like? | Excel Programming | |||
| efficiently copy values from a Range of cells to an array (in VB.N | Excel Programming | |||
| efficiently copy values from a Range of cells to an array (in VB.N | Excel Programming | |||
| Create Array From Values in range | Excel Programming | |||
Linear Mode
