title: Copy cell value to active cell on double click
body: <p>When I double click on a cell, I want the value of the cell 3 columns to the left to appear in the cell that I double clicked on.</p>
  
  <p>Doesn't work</p>
  
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As   Boolean)
  Cancel = True
  ActiveCell.Value = ActiveCell.Offset(0, -3).Value
  End Sub
  </code></pre>