Thread: Array write
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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?
Reply With QuoteReply With Quote