Posted to microsoft.public.excel.programming

Susan

external usenet poster

Posts: 1,117

Block addition of ranges

then AFAIK, you're out of luck, unless you haul out the magic wand &
give it a wave.

the only thing you could do without using the clipboard is having
a 3rd exact-size range that has each cell say
=sum('sheet1!'v6+'sheet2!'v6)

:)
susan

On May 23, 10:48 am, wrote:
I should add that I don't want to do any cell by cell commands.

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
Block addition of ranges	[email protected]	Excel Programming	1	May 24th 07 01:56 AM
Block addition of ranges	[email protected]	Excel Programming	2	May 23rd 07 04:07 PM
if/then block within another if/then block needs a loop	Janis	Excel Programming	1	September 8th 06 10:01 PM
Addition?	Frodo	Excel Discussion (Misc queries)	3	July 22nd 06 01:15 PM
row addition	Threshold	Excel Worksheet Functions	3	March 17th 05 08:08 PM

All times are GMT +1. The time now is 06:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us