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?

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?