| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array write
Can I write into an 10x10 array all-cells-at-once, without loops? how?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array write
Sub abc()
Set MyRange = Range("A1:J10") MyRange.Copy Destination:=Range("A20") End Sub "Bharath Rajamani" wrote: Can I write into an 10x10 array all-cells-at-once, without loops? how? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array write
can you write that into an array dim (1 to 10, 1 to 10) without a loop ? thx!
"Joel" wrote: Sub abc() Set MyRange = Range("A1:J10") MyRange.Copy Destination:=Range("A20") End Sub "Bharath Rajamani" wrote: Can I write into an 10x10 array all-cells-at-once, without loops? how? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array write
You can if the array is originally declared as a dynamic array. E.g.,
Dim MyArray() ReDim MyArray(1 to 10, 1 to 10) MyArray = Range("A1:J10") Alan Beban Bharath Rajamani wrote: can you write that into an array dim (1 to 10, 1 to 10) without a loop ? thx! "Joel" wrote: Sub abc() Set MyRange = Range("A1:J10") MyRange.Copy Destination:=Range("A20") End Sub "Bharath Rajamani" wrote: Can I write into an 10x10 array all-cells-at-once, without loops? how? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array write
Thx Alan, this works. Is the converse possible i.e.: to write from an array
into a worksheet range without using a for..next loop ? "Alan Beban" wrote: You can if the array is originally declared as a dynamic array. E.g., Dim MyArray() ReDim MyArray(1 to 10, 1 to 10) MyArray = Range("A1:J10") Alan Beban Bharath Rajamani wrote: can you write that into an array dim (1 to 10, 1 to 10) without a loop ? thx! "Joel" wrote: Sub abc() Set MyRange = Range("A1:J10") MyRange.Copy Destination:=Range("A20") End Sub "Bharath Rajamani" wrote: Can I write into an 10x10 array all-cells-at-once, without loops? how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to write an array to a range without looping | Excel Worksheet Functions | |||
| Write 3d array to range | Excel Programming | |||
| write array to range | Excel Programming | |||
| Write 1st and 2nd dimension array values to cells | Excel Programming | |||
| Write to Array from other closed Excel file | Excel Programming | |||
Linear Mode
