Posted to microsoft.public.excel.misc

George

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
dynamically building references to named ranges	[email protected]	Excel Discussion (Misc queries)	1	January 3rd 06 10:23 PM
help with inserting a cell value into a named formula	Ed	Excel Discussion (Misc queries)	1	November 25th 05 10:14 PM
Replace a spreadsheets named cells/ranges with exact cell address.	David McRitchie	Excel Discussion (Misc queries)	0	September 28th 05 08:59 PM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Named Cell Ranges	Blackcat	Excel Discussion (Misc queries)	1	December 9th 04 09:57 AM

All times are GMT +1. The time now is 11:33 PM.

About Us

"It's about Microsoft Excel"