title: How to keep hyperlink as it is while copying from one workbook to another using vba?
body: <p>I'm new to VBA, I have a workbook in which a cell has value with hyperlink and I'm trying to copy that cell value along with hyperlink to another workbook e.g. as it is in excel's <strong>keep source format functionality</strong>.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>Worksheets("Sheet1").Cells(1, 2) = objWorkbook.Worksheets(1).Cells(1, 2)
  </code></pre>
  
  <p>This code is just moving the value but I need value with its hyperlink.</p>