title: Excel VBA update the date in a cell if anything changes in a range of cells in the same row
body: <p>I have a code where the date is updated in the cell in column D if any change was made in the cell in the same row in column F:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  ' Code to put the date of the latest update following a change in the corresponding cell in column F
  Dim WorkRng As Range
  Dim rng As Range
  Dim xOffsetColumn As Integer
  Set WorkRng = Intersect(Application.ActiveSheet.Range("F:F"), Target)
  xOffsetColumn = -2 'The date is put 2 columns to the left of column F
  If Not WorkRng Is Nothing Then
      Application.EnableEvents = False
      For Each rng In WorkRng
         If Not VBA.IsEmpty(rng.Value) Then
            rng.Offset(0, xOffsetColumn).Value = Now
            rng.Offset(0, xOffsetColumn).NumberFormat = "dd/mm/yyyy"
         Else
            rng.Offset(0, xOffsetColumn).ClearContents
         End If
     Next
     Application.EnableEvents = True
  End If
  End Sub
  </code></pre>
  
  <p>Now I need to adapt this code so that the date is updated in the cell in column D if any change was made in the cells in the same row in columns F to K.</p>
  
  <p>I have very little VBA knowledge and would be grateful for any help in adapting the code.</p>