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)
Thanks in advance
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)
> Thanks in advance
> 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)
> > Thanks in advance
> > Graham



Fri, 22 Jul 2005 10:38:48 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Passing arguments to my offset formula

2. Offset formula

3. Verify my OFFSET formula is corrrect?

4. offset formula

5. Offset formula by one row with macro

6. Newbie, Why error in OFFSET formula?

7. Offset formula?

8. blank cells in offset formula used in chart

9. embedded reference cell in offset formula

10. Offsetting ranges in a formula...


 
Powered by phpBB® Forum Software © phpBB Group