title: How do I copy a cell that has an online hyperlink to another cell?
body: <p>I want to copy a cell that has an online hyperlink to another cell (while keeping the hyperlink intact), but every time I try this it just copies the value without the hyperlink.</p>
  
  <p>=hyperlink does not work because that just hyperlinks to my cell's location; not the online hyperlink. </p>
  
  <p>I tried to copy using vba but I ran into the same problem.</p>
  
  <pre><code>Worksheets("X").Range("AD17") = Worksheets("Y").Range("A2")
  </code></pre>