Hi
I have some code which has an text output and I need to change the latter part of the text to a different colour. Is this possible?
For e.g. I have added
<code> & cell.Offset(0, -1).Color = vbRed </code>
to the end of
<code> " ( POSITION NUMBER : " & cell.Offset(0, -1).Value & cell.Offset(0, -1).Color = vbRed & " ) " </code>
but not getting the desired output.
Any help would be appreciated.
TIA