title: How to make part of a text bold
body: <p>I have the following function in vba:</p>
  
  <pre><code>Function ConcatinateAllCellValuesInRange(sourceRange As Excel.Range) As String
          Dim finalValue As String
  
          Dim cell As Excel.Range
  
          i = 0       
          For Each cell In sourceRange.Cells
          i = i + 1
          Rzad = cell.Row
              finalValue = finalValue &amp; CStr(i) &amp; ". " &amp; CStr(Sheets(1).Cells(Rząd, 6)) &amp; "/" &amp; CStr(Sheets(1).Cells(Rząd, 7)) &amp; ": " &amp; Format(cell.Value, Bold) &amp; "; " &amp; vbCrLf
  
          Next cell
  
          ConcatinateAllCellValuesInRange = finalValue
      End Function
  </code></pre>
  
  <p>I want to make a part of the text bold but 'Format(cell.Value, Bold)' does not work. Can you suggest a solution?</p>