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.
Bookmarks