<div>
possible reasons:-<br />
- you have the sheet protected<br />
- your formula is incorrect (missing bracket or parameter)<br />
<br />
Can you post an example - or at least complete &nbsp;code lines &nbsp;above and below
</div>


<div>
OK full formula: -<br />
ActiveCell.Formula = &quot;=IF(AA3.value='Y',(((V3+I<wbr />3+J3+K3)-(<wbr />L3+M3+N3+O<wbr />3))*-1)+C3<wbr />,((V3+I3+J<wbr />3+K3)-(L3+<wbr />M3+N3+O3))<wbr />*-1)&quot;<br />
<br />
It was this: ((V3+I3+J3+K3)-(L3+M3+N3+O<wbr />3))*-1<br />
<br />
The iff statement breaks it so 'AA3.value='Y'' must be wrong
</div>


<div>
the formula within the &quot;&nbsp;must be a valid excel formula on it own - ie: you should be able to cut it from the code and put it in a cell - if you do that the error generated will highlight what is wrong with the formula. <br />
<br />
a couple of guesses:<br />
<br />
- if you are looking at the value in AA3 then use it as though in the spreadsheet:<br />
&nbsp;= &quot;=if(AA3 = 'Y'.....<br />
<br />
<br />
- if aa3.value is an object or variable from within the script and you want to use its current value: <br />
&nbsp;&quot;=if(&quot; &amp;&nbsp;aa3.value &amp;&nbsp;&quot;='Y'....
</div>


<div>
OK to simplify, this still gives the error: -<br />
<br />
ActiveCell.Formula = &quot;=IF(AA3='Y','Y','')&quot;
</div>


<div>
Got there nearly same time! Answer is also here: -<br />
<a href="http://www.ozgrid.com/forum/showthread.php?t=42515" rel="ugc">http://www.ozgrid.com/forum/showthread.php?t=42515</a>
</div>


<div>
<div class="content wysiwyg-content">
I am trying to insert a formula that checks for a 'Y' in a cell and I get the above error so the syntax must be wrong: -<br />
ActiveCell.Formula = &quot;=IF(AA3.value='Y' etc.<br />
<br />
Can anyone help?
</div>
</div>


I am trying to insert a formula that checks for a 'Y' in a cell and I get the above error so the syntax must be wrong: -
ActiveCell.Formula = "=IF(AA3.value='Y' etc.

Can anyone help?

Excel 2007 VBA error 1004

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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