Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
***is*** there any way of doing it without going cell by cell (via
macro)??? :) susan On May 23, 11:33 am, Tom Ogilvy wrote: No, it is cell by cell, but the OP's added requirement was not visible when I posted. If he doesn't want to use it, he can use any that are offered that meet his specs. -- Regards, Tom Ogilvy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block addition of ranges
Sub AddTo2()
Set rng1 = Range("A1:D3") Set rng2 = Range("F1:I3") rng2.Value = Evaluate(rng1.Address _ & "+" & rng2.Address) End Sub -- Regards, Tom Ogilvy "Susan" wrote in message ups.com... ***is*** there any way of doing it without going cell by cell (via macro)??? :) susan On May 23, 11:33 am, Tom Ogilvy wrote: No, it is cell by cell, but the OP's added requirement was not visible when I posted. If he doesn't want to use it, he can use any that are offered that meet his specs. -- Regards, Tom Ogilvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Block addition of ranges | Excel Programming | |||
Block addition of ranges | Excel Programming | |||
Block addition of ranges | Excel Programming | |||
Block addition of ranges | Excel Programming | |||
if/then block within another if/then block needs a loop | Excel Programming |