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

On Fri, 28 Apr 2006 16:21:14 -0500, "Chip Pearson" wrote:

George,

I misread your post. Try the following code instead.

Dim Ndx As Long
For Ndx = 1 To Range("X").Rows.Count
Range("Z")(Ndx) = Range("X")(Ndx) + Range("Y")(Ndx)
Next Ndx


That's nice - thank you.

George