Error in named cell formula

[Gregfox]

Error in named cell formula
Hi, I am trying to multiply a named cell with an unnamed cell and can’t find a solution. I have the following named cells A1-one, B1=two. If I use code .Range("C1").FormulaR1C1 = "=(one*two)", I get the correct answer, however if I use the code .Range("C1").FormulaR1C1 = "=(one*B2)" I get #NAME?
Soooo, my question is
A. can I multiply a named cell with an un-named cell?
B. What does .FormulaR1C1 mean?

Sub testname()
With ThisWorkbook.Worksheets("sheet1")
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
.Range("one").Formula = (5#)
.Range("two").Formula = (10#)
.Range("C1").FormulaR1C1 = "=(one*b2)"
<o:p></o:p>
End With
End Sub

<o>Thanks.</o>

 

[mikerickson]

Because B2 is in A1 notation. Try

.Range("C1").FormulaR1C1 = "=one*R[1]C[-1]" :Rem relative reference
Rem or
.Range("C1").FormulaR1C1 = "=one*R2C2" :Rem absolute reference

 

[VoG]

It isn't an R1C1 formula which is why it fails. Try

Range("C1").Formula = "=(one*b2)"

 

[jasonb75]

You can, or at least should be able to, B2 isn't an R1C1 reference, thats where the problem is coming from.

B2 in R1C1 reference terms is R2C2 (Row 2 Column 2)

.Range("C1").Formula = "=(one*b2)"
.Range("C1").FormulaR1C1 = "=(one*R2C2)"

Hopefully that expalins what formulaR1C1 means as well.

 

[Gregfox]

Thank all of you, your reply made clear the problem.