Hi Guys, Is it possible for a macro to copy highlighted text in excel and transfer it to a word document? It gives me trouble always. please help me with this. The file im trying to create contains different highlighted text in which conditional formatting was used. Lend me your brains please.