<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a question regarding syntax on a line of code that is currently giving me an error.<br />
<br />
Please note, I am new to Excel VBA and have the &quot;Require Variable Declaration&quot; option selected thus Option Explicit.<br />
<br />
I have enclosed the line of code that is bugging with &quot;Syntax Error&quot;<br />
<br />
Any help?<br />

<pre><code id="code-5550753">Range(&quot;ExportData &amp; &quot;!A1&quot;).PasteSpecial xlPasteAll
</code></pre>
</div>
</div>


Hi All,

I have a question regarding syntax on a line of code that is currently giving me an error.

Please note, I am new to Excel VBA and have the "Require Variable Declaration" option selected thus Option Explicit.

I have enclosed the line of code that is bugging with "Syntax Error"

Any help?

Excel VBA Syntax

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