VBA vbNewLine but with no extra space
<p>I'm adding a Title to a chart but I keep getting an extra space (white space) between the two strings when I use vbNewLine. </p>

<pre><code>myChart.ChartTitle.Text = "Distance to Default for" &amp; vbNewLine &amp; compName
</code></pre>

<p>note <code>compName</code> is another string I previously define. </p>