rrhandle8

<div>
It is accepting C to be an undeclared variable but when used it does not know what it is.<br />
<br />
Instead use Cells(2,3)= &quot;what ever you want here&quot;<br />
Alternatively use Range(&quot;C2&quot;)= &quot;what ever you want here&quot;
</div>


It is accepting C to be an undeclared variable but when used it does not know what it is.

Instead use Cells(2,3)= "what ever you want here"
Alternatively use Range("C2")= "what ever you want here"

<div>
<div class="content wysiwyg-content">
I am trying to paste this formula into a cell.<br />
<br />
Cells(2, C).Formula = &quot;=if($ES!RC[223]&lt;&gt;0,1,0)&quot;<br />
<br />
I get the following error.<br />
<br />
Run-time error '1004':<br />
Application-defined or object-defined error
</div>
</div>


I am trying to paste this formula into a cell.

Cells(2, C).Formula = "=if($ES!RC[223]<>0,1,0)"

I get the following error.

Run-time error '1004':
Application-defined or object-defined error

Paste Excel Formula With VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.