title: Excel VBA Target.Offset(#,#).Value Explained
body: <p>I have a question regarding one piece of code form a sub I have in a workbook I am trying to use: </p>
  
  <pre><code>   Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
          Dim firstCell As String
  
              On Error GoTo Done:
  
              If Target.Column = 6 And Target.Cells.Count = 1 Then
                  Cancel = True
                  ***firstCell = Target.Offset(0, -2).Value***
                  If firstCell = "" Then GoTo Done:
                  Sheets("Sheet1").Activate
                  Sheets("Sheet1").Range("$D$1").Value = firstCell
              End If
      Done:
      End Sub
  </code></pre>
  
  <p>The part that confuses me the most are the values <code>(0,-2)</code> in the parenthesis of the <code>Target.Offset(0,-2)</code> expression. Can anyone explain what that snipit of code is doing in the sub?</p>