Hi,
I need to copy and paste a formula from cell D18 [formula is
=(9-SUM(SEP07))], SEP07 being the range D1929, into cell E18. this I have
managed to do but I then need the formula to incorporate a new range, i.e.
=(9-SUM(OCT07)), OCT07 being range E19:E29, when the formula is pasted into
the new cell (E18).

The people in this discussion group have been very helpful in the past and
hopefully some one can suggest a macro to perform this task.
thanks in advance
sevi

Why don't you just use the range address instead of its name
=(9-SUM(D$19$29))
Then when you copy it, the column will adjust.
James
"sevi61" <(E-Mail Removed)> wrote in message
news:1741DFE5-796E-4684-B951-(E-Mail Removed)...
> Hi,
> I need to copy and paste a formula from cell D18 [formula is
> =(9-SUM(SEP07))], SEP07 being the range D1929, into cell E18. this I
> have
> managed to do but I then need the formula to incorporate a new range, i.e.
> =(9-SUM(OCT07)), OCT07 being range E19:E29, when the formula is pasted
> into
> the new cell (E18).
>
> The people in this discussion group have been very helpful in the past and
> hopefully some one can suggest a macro to perform this task.
> thanks in advance
> sevi

Hey Zone,

thanks mate, that works a treat and I can't believe that I didn't see it
myself! sometimes I try and make things too complicated I guess. Thanks again
for your help, it is much appreciated as always.

regards,

sevi

"Zone" wrote:

> Why don't you just use the range address instead of its name
> =(9-SUM(D$19$29))
> Then when you copy it, the column will adjust.
> James
> "sevi61" <(E-Mail Removed)> wrote in message
> news:1741DFE5-796E-4684-B951-(E-Mail Removed)...
> > Hi,
> > I need to copy and paste a formula from cell D18 [formula is
> > =(9-SUM(SEP07))], SEP07 being the range D1929, into cell E18. this I
> > have
> > managed to do but I then need the formula to incorporate a new range, i.e.
> > =(9-SUM(OCT07)), OCT07 being range E19:E29, when the formula is pasted
> > into
> > the new cell (E18).
> >
> > The people in this discussion group have been very helpful in the past and
> > hopefully some one can suggest a macro to perform this task.
> > thanks in advance
> > sevi
>
>
>

Glad to help! James
"sevi61" <(E-Mail Removed)> wrote in message
news:FF2C8EA8-46DA-4FFA-B6F6-(E-Mail Removed)...
> Hey Zone,
>
> thanks mate, that works a treat and I can't believe that I didn't see it
> myself! sometimes I try and make things too complicated I guess. Thanks
> again
> for your help, it is much appreciated as always.
>
> regards,
>
> sevi
>
> "Zone" wrote:
>
>> Why don't you just use the range address instead of its name
>> =(9-SUM(D$19$29))
>> Then when you copy it, the column will adjust.
>> James
>> "sevi61" <(E-Mail Removed)> wrote in message
>> news:1741DFE5-796E-4684-B951-(E-Mail Removed)...
>> > Hi,
>> > I need to copy and paste a formula from cell D18 [formula is
>> > =(9-SUM(SEP07))], SEP07 being the range D1929, into cell E18. this I
>> > have
>> > managed to do but I then need the formula to incorporate a new range,
>> > i.e.
>> > =(9-SUM(OCT07)), OCT07 being range E19:E29, when the formula is pasted
>> > into
>> > the new cell (E18).
>> >
>> > The people in this discussion group have been very helpful in the past
>> > and
>> > hopefully some one can suggest a macro to perform this task.
>> > thanks in advance
>> > sevi
>>
>>
>>