JKwan
02-08-2010, 12:20 PM
I know arrays are much faster in terms of working / writing to the sheet directly. So, I am trying to work on something simple, but I was not able to figure it out as to how to do it.
so if I have the following code
Dim ary As Variant
ary = Range("A1:C7")
Range("A10") = ary
Range("a10:C16") = ary
- A10 will only get one value of the array - not all!!
- Second Range works - but since the array is varible everytime, I cannot hard code the Range!!
so if I have the following code
Dim ary As Variant
ary = Range("A1:C7")
Range("A10") = ary
Range("a10:C16") = ary
- A10 will only get one value of the array - not all!!
- Second Range works - but since the array is varible everytime, I cannot hard code the Range!!