Thread: Write from variant array into range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bharath Rajamani Bharath Rajamani is offline
external usenet poster
  
Posts: 41
Default 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?
Reply With QuoteReply With Quote