<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have this code in the VBA Editor<br />
<br />
ActiveCell.FormulaR1C1 = &quot;=DATE(YEAR(Update!AB1),MO<wbr />NTH(Update<wbr />!AB1),0)&quot;<br />
<br />
It produces an error in excel, the formula it drops out is<br />
<br />
=DATE(YEAR(Update!'AB1'),M<wbr />ONTH(Updat<wbr />e!'AB1'),0<wbr />)<br />
<br />
I notice if i take the apostrophes away from AB1, the formula works, how can i fix this in the editor?<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi,

I have this code in the VBA Editor

ActiveCell.FormulaR1C1 = "=DATE(YEAR(Update!AB1),MONTH(Update!AB1),0)"

It produces an error in excel, the formula it drops out is

=DATE(YEAR(Update!'AB1'),MONTH(Update!'AB1'),0)

I notice if i take the apostrophes away from AB1, the formula works, how can i fix this in the editor?

Thanks
Seamus

VBA Error

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