[AccessD] Programmatically change cell formulae in Ecel

Wed Nov 28 14:54:22 CST 2007

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