Hey everyone,
I am changing an output string from its position in a cell onto a OLEObject.Caption.
Previously the cell (range) had a nice mix of colours, making the fairly complex string very legible. I managed this through the following code:
rng.Characters(Start:=12, Length:=27).Font.Color = RGB(255, 0, 0)
My question is, is there a code I can apply to the object.forecolor code?
o1.Object.ForeColor = RGB(0, 0, 0)
...and then, as above, letters starting from position 12 to 27 should be red.
I guess a workaround could be positioning a graphical element, but this would also require establishing its .left value, based on I am not sure what...
Thank you for any help!
Bookmarks