Hi,
I have a excel VBA macro which copies contents from cells to a word document as below

objDoc.Content.Find.Execute ActiveSheet.Cells(4, Columns(i).Address).Value, ReplaceWith:=ActiveSheet.Cells(j, Columns(i).Address).Value


My problem is, one of my Replace with cells has multiple lines in it.So, the word doc is getting replaced as
1. ABC 2. CDS

instead of
1. ABC
2. CDS

Can somebody help me on how to achieve this?

Also let me know if I can paste a cell comments to the word doc in the same way.

Appreciate help on this.