Offset formula 
Author Message
 Offset formula

Please how can I fill down a formula in column O  "=N2*M2
    using the range as below

    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select

Thanks for any help here.
Grah



Tue, 19 Jul 2005 10:46:53 GMT  
 Offset formula
Hi,

In a line:
   Range(Range("a2"), Range("a2").End(xlDown)).Formula
= "=n2*m2"

Or, if you need range ("a2") elsewhere, it would be a good
idea to store it in a variable:
   Dim Rg As Range
   Set Rg = Range("a2")
   Range(Rg, Rg.End(xlDown)).Formula = "=n2*m2"
Now you can use Rg (representing Range A2) for other
purpose if needed

Regards,
Sbastien

Quote:
>-----Original Message-----
>Please how can I fill down a formula in column O  "=N2*M2
>    using the range as below

>    Range("A2").Select
>    Range(Selection, Selection.End(xlDown)).Select

>Thanks for any help here.
>Grah



Tue, 19 Jul 2005 11:13:06 GMT  
 Offset formula
hMMMNmm My fault not enough information

I need the formular to go into column O is is a offset formula
So I need to know how to use the offset filldown
Grah


Quote:
> Please how can I fill down a formula in column O  "=N2*M2
>     using the range as below

>     Range("A2").Select
>     Range(Selection, Selection.End(xlDown)).Select

> Thanks for any help here.
> Grah



Tue, 19 Jul 2005 11:29:19 GMT  
 Offset formula
Range(Range("A2"),Range("A2").End(xldown)). _
   offset(0,14).Formula = "=N2*M2"

Regards,
Tom Ogilvy


Quote:
> Please how can I fill down a formula in column O  "=N2*M2
>     using the range as below

>     Range("A2").Select
>     Range(Selection, Selection.End(xlDown)).Select

> Thanks for any help here.
> Grah



Tue, 19 Jul 2005 11:12:05 GMT  
 Offset formula
See my answer.
Regards,
Tom Ogilvy


Quote:
> hMMMNmm My fault not enough information

> I need the formular to go into column O is is a offset formula
> So I need to know how to use the offset filldown
> Grah



> > Please how can I fill down a formula in column O  "=N2*M2
> >     using the range as below

> >     Range("A2").Select
> >     Range(Selection, Selection.End(xlDown)).Select

> > Thanks for any help here.
> > Grah



Tue, 19 Jul 2005 14:40:02 GMT  
 Offset formula
Thanks very much both of you guys
Just could'nt put it together
Regards
Grah


Quote:
> Range(Range("A2"),Range("A2").End(xldown)). _
>    offset(0,14).Formula = "=N2*M2"

> Regards,
> Tom Ogilvy



> > Please how can I fill down a formula in column O  "=N2*M2
> >     using the range as below

> >     Range("A2").Select
> >     Range(Selection, Selection.End(xlDown)).Select

> > Thanks for any help here.
> > Grah



Tue, 19 Jul 2005 14:55:53 GMT  
 Offset formula
Thanks To Works very nicely
Appreciate your help indeed
Regards
Grah


Quote:
> See my answer.
> Regards,
> Tom Ogilvy



> > hMMMNmm My fault not enough information

> > I need the formular to go into column O is is a offset formula
> > So I need to know how to use the offset filldown
> > Grah



> > > Please how can I fill down a formula in column O  "=N2*M2
> > >     using the range as below

> > >     Range("A2").Select
> > >     Range(Selection, Selection.End(xlDown)).Select

> > > Thanks for any help here.
> > > Grah



Wed, 20 Jul 2005 23:46:29 GMT  
 
 [ 7 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