Word interop problem : String parameter too long.

; what should I assign to Find.Replacement.ParagraphFormat ?

If you know what formatting the destination cell should have, assign it to Find.Replacement.ParagraphFormat will make the replaced text use this format.

And you see, each cell in Word document has it's own paragraph. If you saved the ParagraphFormat before replacement and reassign it after replace has been done, you may see the formatting corrected.

Or will just assigning Cell.Range.Paragraphs to the new cell copy the contents there? I don't have the code to test it out here.

Just a few thoughts.