View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George
 
Posts: n/a
Default VBA: sum two named ranges, cell-by-cell

If I have x = A1:A4, y= B1:B4, z = C1:C4. Is there a way in a VBA script to do
z[i] = x[i] + y[i]?

Thanks,
George