| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
| help with inserting a cell value into a named formula | Excel Discussion (Misc queries) | |||
| Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Named Cell Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
