<div>
Yes of course. You are assigning an A1 style formula to the R1C1 formula property. <br />
<br />
If you want to assign that formula you should just use the 'mycell.formula' property
</div>


Yes of course. You are assigning an A1 style formula to the R1C1 formula property.

If you want to assign that formula you should just use the 'mycell.formula' property

<div>
Looks like a split-second clash of experts :)
</div>


Looks like a split-second clash of experts :)

<div>
<div class="content wysiwyg-content">
I'm getting error when I assign below formula to field A21 <br />
<br />
Run time error 1004 <br />
Application defined or object defined error <br />
&nbsp;<br />
&nbsp; &nbsp; Range(&quot;A21&quot;).Select<br />
&nbsp; &nbsp; ActiveCell.FormulaR1C1 = &quot;=VLOOKUP(A2,Sheet2!$A$10:<wbr />$R$90,3,FA<wbr />LSE)&quot;<br />
&nbsp; &nbsp; Range(&quot;A21&quot;).Select<br />
<br />
If I apply same formula manually on cell A21 by pressing F2 the commend works.
</div>
</div>


I'm getting error when I assign below formula to field A21 

Run time error 1004 
Application defined or object defined error 
 
    Range("A21").Select
    ActiveCell.FormulaR1C1 = "=VLOOKUP(A2,Sheet2!$A$10:$R$90,3,FALSE)"
    Range("A21").Select

If I apply same formula manually on cell A21 by pressing F2 the commend works.

excel vba how to add formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.