VBA FormulaR1C1 problem

[Lochnagar]

Hi,

I'm trying to input a formula into a cell using the FormulaR1C1 method, but I've hit a small problem. Basically the formula I'm inputing refers to the adjacent cells

e.g. Activecell.FormulaR1C1 = "=RC[-1]+RC[-2]..."

However what I'm wondering is is it possible to input a formula that refers to a fixed cell (in the example below cell $B$3) in addition to adjoining cells

e.g. Activecell.FormulaR1C1 = "=RC[-1]+RC[-2]+$B$3",


Any help or suggestions will be greatly appreciated.

Thanks in advance,

Lochnagar

 

[Norie]

Lochnagar

You can't mix R1C1 and A1 notation like that.

Try this.

ActiveCell.FormulaR1C1 = "=RC[-1]+RC[-2]+R3C2"

 

[Lochnagar]

Thanks Norie, just what I was after.