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?