title: inserting page break in word using excel macro
body: <p>I am creating a macro that copies data from excel into word.   I can't get the macro to insert a page break after I just copied the range of cells into word.  I get the following error </p>
  
  <blockquote>
    <p>Object doesn't support this property or method.</p>
  </blockquote>
  
  <p>I am guessing this happens because the copied data in Word is still highlighted  and I need to get a cursor at the bottom of the new copied date before I try to insert a page break.   </p>
  
  <p>How do I do this?  </p>
  
  <p>This is a section of the code that is not working - actually the last line of the code but I thought I should show you right before as well:</p>
  
  <pre><code>        Range("A1:F25").Select
           Selection.Copy
  
           appWD.Documents.Add
  
           appWD.Selection.PasteSpecial Link:=True, DataType:=wdPasteEnhancedMetafile
           DoEvents
  
  
          appWD.InsertBreak Type:=wdPageBreak
  </code></pre>