View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Varne Varne is offline
external usenet poster
 
Posts: 126
Default 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.