Copying cell formating

[ksucats4me]

I've got a macro written that reads the values of two columns into an array. The first column is either blank or an "x", it is a selection column. The second column has topic titles in it. The macro outputs a condensed list of all those topics "selected" but having an "x" in the column to the left of it. This works just fine, no problems. We want to format the topic titles so the first five words are bold and the rest of the title is unformatted. This is also relatively easy to do. The trick is getting the formatting to hold when the macro executes and creates the compiled list. Using the macro, the output is completely unformatted. I've experimented with with the paint brush formatting, but it produces an output that is completely bold.

Any suggestions on how we can get this macro to replicate the same format as the item in the master list? I've also toyed with simple copy/paste and it works, but I'm not in love with the idea of executing repetitious copy/paste commands.

Thanks in advance.