Can't seem to Google up a working solution to paste and fit a large copied range from XL to a Word document. Here's my unsuccessful attempts. The WordApp is the active Word process. Any help welcomed. Dave
'WordApp.ActiveDocument.content.PasteSpecial Placement:=0 'wdInLine WordApp.ActiveDocument.content.Paste With WordApp.ActiveDocument .Range.autofitbehavior 2 'wdAutoFitWindow '.Range(0, .Characters.Count).autofitbehavior 2 '.content.autofitbehavior 2 End With