[AccessD] Programmatically change cell formulae in Ecel

Arthur Fuller fuller.artful at gmail.com
Wed Nov 28 15:44:58 CST 2007


Never mind, I looked it up.

A.

On Nov 28, 2007 3:54 PM, Arthur Fuller <fuller.artful at gmail.com> wrote:

> What's the R1C1 for, Jurgen?
>
> Arthur
>
>
> On Nov 28, 2007 3:17 PM, Jurgen Welz <jwelz at hotmail.com> wrote:
>
> >
> > Arthur:
> >
> > Here is an example from code I use where M refers to a named range cell
> > in a sheet:
> >
> >                .Cells(14, 4).Select
> >  .ActiveCell.FormulaR1C1 =
> > "=IF(M=0,Tender!RC[-1],Tender!RC[-1]*Tender!RC[11])"
>
>
>
> > CiaoJürgen WelzEdmonton
>
>
>



More information about the AccessD mailing list