multiply a named cell by another named cell

[Gregfox]

Hello all, I have three named cells {one, two, and spot}. I would like to know if one could multiply a named cell by another named cell. I have the code below, but it always puts a “0” in “spot”

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 = (15#)
.Range("spot").Formula = (one * two)
End With
End Sub

 

[mikerickson]

try

Range("spot").FormulaR1C1 = "=one*two"

 

[Gregfox]

Thank you worked great!