title: Copy found text including hyperlink to new document
body: <p>My VBA script is searching for a specific text in a Word document and if the found text contains a Hyperlink, I want to copy also the Hyperlink to the new document.</p>
  
  <p>I have tried to do (source is a table in word and so is destination):</p>
  
  <pre><code>With source.Cell(1,1).Range
     .Find.Text = "MyTextToSearch
     .Find.Execute Forward:=True
     .Select
     .Copy
  End With
  destination.Cells(1).Range.Paste
  </code></pre>
  
  <p>The text is copied to the destination but without the hyperlink.
  When I do the same in Word using Find and Copy and Paste (via GUI), everything is copied to the destination</p>
  
  <p>Any suggestions?</p>