Excel VBA: copying a cell with FormulaR1C1

[zeno]

I receive an run-time error message 1004 "autofill method of range class failed" in the following setting, in the 2nd line.
In this instance, I want to copy 1 cell from the cell 2 columns before.

     Range("M3").FormulaR1C1 = "=RC[-2]"
     Range("M3").AutoFill Destination:=Range("M3"), Type:=xlFillDefault

Thank you for your help.

 

[theBardd]

Do you mean

     Range("M3").FormulaR1C1 = "=RC[-2]"
     Range("M3").AutoFill Destination:=Range("L3:M3"), Type:=xlFillDefault

 

[zeno]

I actually only want to copy 1 single cell. Here, it would be copying in cell M3 the cell from 2 columns before, so cell K3.
For that reason I wrote "RC[-2] so that it should look for the cell from 2 columns before (-2).
Unless my interpretation is wrong? I cannot specify which column exactly, because this may change.

 

[Norie]

Have you tried this?

Range("M2:M3").FormulaR1C1 = "=RC[-2]"

 

[zeno]

Thank you for your responses. However, they put multiple fields (2) with that formula, instead of only 1 field. My objective is to only copy the value of 2 previous columns, in this example value of cell K3 copied to M3.
Is it possible to use FormulaR1C1 or should I use another code formula?

 

[Norie]

If you want values in cells copied to other cells you can't use formulas.

 

[theBardd]

Range("M3").Value = Range("K3").Value