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