Hi There,

I have the following code that opens a word template file and copies an excel selected data range from a worksheet to word, but i need it to paste on a selected page of the word document i.e. page 3 or after the last page brake. Is this at all possible, and if so could you please be kind enough to provide some assistance. Many thanks in advance. 

Private Sub CommandButton1_Click()
Set WordApp = CreateObject("word.Application")

WordApp.Documents.Open "G:\excel_program\New folder\Doc1.doc"

WordApp.Visible = True

Range("a1:q23").Copy

WordApp.Selection.PasteSpecial Link:=False, DataType:=wdPasteEnhancedMetafile, _
Placement:=wdInLine, DisplayAsIcon:=False

Set WordDoc = Nothing
Set WordApp = Nothing

End Sub