Reading Chunks of Excel Data
Hi
Is there a VBA technique €“ direct or indirect €“ to read chunks of cells
rather than copying. The following reads b4 to both a1 and a4.
Range("a1,a4").Value = Range("b4,b1").Value
If there is none is there a technique to do copying without selecting or
activating copied or receiving area.
Can someone help?
Thanks.
|