Can you bold specific text in a cell that uses concatenation using VBA?

[rizzo93]

I have a cell containing a formula I use to concatenate content from various cells. I want to be able to only bold a portion of the resulting text in that cell.

My research has shown only scenarios where the text in a cell is just text -- not the result of a formula.

Is what I'm asking for possible with VBA?

I suppose an alternative would be to copy/paste the value of the concatenated cell to another cell and then apply the bold to the text I want.

 

[Fluff]

Is what I'm asking for possible with VBA?

Fraid not. You cannot change the format of part of a cell if it contains a formula.
But your alternative is possible.

 

[rizzo93]

Fraid not. You cannot change the format of part of a cell if it contains a formula.
But your alternative is possible.

Ah, I was afraid of that. But glad that you could confirm it. Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.