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
|