Excel: Formatting a substring within a cell only

Hi all, The task I have requires repeatedly formatting specific words within cells, rather than the whole cell's text. I thought i'd try to write a macro to automate this, but can't seem to find anything about how to format only specific substrings in a cell. I was hoping to have the macro work something like this: select the word you want to format, run the code and it would apply the formatting to that word. Does anyone know what the method would be for achieving this? I would think that there would be something similar to "CurrentSelection", which would be the most straightforward way to go about this. Thanks in advance, Alex

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of December 18, 2014.

For more resources for Microsoft Excel