| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write from variant array into range
can i write in one-step (i.e. no loops) from a dynamic array into a range,
how? Dim myarr() Redim myarr(1 to 10, 1 to 1) myarr = Range("B1:B10") '--Can I write myarr to Range("A1:A10") in one step? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write from variant array into range
Hi Bharath,
'============= Public Sub Tester() Dim myarr As Variant myarr = Range("B1:B10").Value Range("A1:A10") = myarr End Sub '<<============= --- Regards, Norman "Bharath Rajamani" wrote in message ... can i write in one-step (i.e. no loops) from a dynamic array into a range, how? Dim myarr() Redim myarr(1 to 10, 1 to 1) myarr = Range("B1:B10") '--Can I write myarr to Range("A1:A10") in one step? |
| 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 | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Best way to paste a variant array into a range? | Excel Programming | |||
Linear Mode
