<div>
Try:<br />
<br />

<pre><code id="code-20-35764825-1">v_WksNamesStr = &quot;RequirementSummary&quot;</code></pre>
</div>


Try:



v_WksNamesStr = "RequirementSummary"

<div>
It looks like you had too many doublequotes and a superfluous comma
</div>


It looks like you had too many doublequotes and a superfluous comma

<div>
Not sure if the comma is part of the string but if it is, then you have to do like this:<br />
<br />
v_WksNamesStr = &quot;RequirementSummary,&quot;
</div>


Not sure if the comma is part of the string but if it is, then you have to do like this:

v_WksNamesStr = "RequirementSummary,"

<div>
Hi, did you notice that that was exactly what I proposed?<br />
<br />
Saqib
</div>


Hi, did you notice that that was exactly what I proposed?

Saqib

<div>
<div class="content wysiwyg-content">
I want to set my string variable, v_WksNamesStr, equal to the value of &quot;Requirements&quot;, The code looks like this:<br />
<br />
v_WksNamesStr = &quot;&quot;RequirementSummary&quot;,&quot;<br />
<br />
Its looking for more after the comma. 
</div>
</div>


I want to set my string variable, v_WksNamesStr, equal to the value of "Requirements", The code looks like this:

v_WksNamesStr = ""RequirementSummary","

Its looking for more after the comma. 

How do I use a comma in a string?

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