Bolding a specific part of cell : <p>I have a cell that is referenced as <code>="Dealer: " &amp; CustomerName</code>.
CustomerName is a dictionary referenced name. How could I go along of bolding only "Dealer:" and not the Customer name.</p>

<p>Example:</p>

<p><strong>Dealer:</strong> Josh</p>

<p>I have tried</p>

<pre><code>Cells(5, 1).Characters(1, 7).Font.Bold = True
</code></pre>

<p>But it only seems to work on non referenced cells only. How could I get this to work on a referenced cell?</p>
