I am writing a macro to automate the updating of text records. For example, in an existing file I have a text record (in a single cell) like:
and in a separate file containing today's updates, the corresponding record says:
I want to add the new information to the existing record in my existing file (which is pretty simple). But the problem is that I manually highlight certain text in my existing file (in bold red text) like this:
and when I use a macro to concatenate that existing text with the (new) added text from the other file, my manually-highlighted text gets set back to plain (black) text. So instead of this:
I get this (red highlighting gone):
Is there any way for a macro to append new text into an existing cell, while retaining whatever individual font modifications exist within the original text?
Bookmarks