This question already has an answer here:
I’m trying to concatenate a string out of some string bits and variable data with the code that looks like this:
HeadersRange.Text = "ID 1: " & ID1_value & "ID 2: " & ID2_value
The end result should look like this:
ID 1: and
ID 2: bits are in bold text while the numbers are not. How do I achieve this? Neither “string” nor “integer” data types content the “font” property, so I can’t make
ID 1 and
ID 2 bold before I insert them. I could concatenate the string, and then do the font formatting on the several parts of the string, but navigating the range is messy and requires me to know the amount of words in every bit up front. What is the best solution?