Offset Formula
Author Message
Offset Formula

Hi Appreciate any help on this.
I still have'nt come to grips with entering formula in an offset column
(1) column a is the column  to use to decide where the data ends
(2) Column d is the offset column where the formula go into starting at row2
The formula is
=c2-time(1,0,0)
Graham

Fri, 22 Jul 2005 09:46:48 GMT
Offset Formula
Dim rng as Range
set rng = Range(Range("A2"),Range("A2").End(xldown))
rng.offset(0,3).Formula = "=C2-Time(1,0,0)"

Regards,
Tom Ogilvy

Quote:
> Hi Appreciate any help on this.
> I still have'nt come to grips with entering formula in an offset column
> (1) column a is the column  to use to decide where the data ends
> (2) Column d is the offset column where the formula go into starting at
row2
> The formula is
> =c2-time(1,0,0)
> Graham

Fri, 22 Jul 2005 09:56:42 GMT
Offset Formula
Thanks Tom I appreciate your help and I wish to say you have helped me in
the past with this offset code.
Regards
Graham

Quote:
> Dim rng as Range
> set rng = Range(Range("A2"),Range("A2").End(xldown))
> rng.offset(0,3).Formula = "=C2-Time(1,0,0)"

> Regards,
> Tom Ogilvy

> > Hi Appreciate any help on this.
> > I still have'nt come to grips with entering formula in an offset column
> > (1) column a is the column  to use to decide where the data ends
> > (2) Column d is the offset column where the formula go into starting at
> row2
> > The formula is
> > =c2-time(1,0,0)