Why is command offsetting value?

Whilst writing a macro I accidently used a range variable instead of the Cells command which acted like an Offset comand.
Can anyone explain how this works

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim rCell As Range
   Dim lRow As Long
   Dim lDist As Long
   
   For Each rCell In Target
      lRow = rCell.Row
      lDist = Cells(lRow, "e").Value - Cells(lRow, "d").Value
      ' i meant to use
      'Cells(lRow, "f").Value = lDist 
      'Accidental ly used  the following command 
      'which offsets rows from rCell by the value
      'of lrow - 1 
      rCell(lRow, "f").Value = lDist
   Next
End Sub

Hi Mudraker.

It seems that Excel is interpreting your code to be an Offset much like you can use Cells(1,1) instead of Cells(1,1).Value. It's not something I have come across before.

I don't quite follow your code. What is it supposed to do because when i edit it to your original intentin it does nothing. You don't seem to set the Target.

Being a worksheet change event macro the target range is set by the cells that are changed on the sheet.
I have a need to paste multiple cells into the sheet which all pasted cell needs to be tested for certain data. This is why I am using the For loop.

The posted code is only a fraction of the total code & was just to show the reason for my query. My actual code does a lot with the pasted data depending on the column it is in.

This part of the code was to subtract a cell value from another cell and place the result into column f of the same row.

Your explanation is about as good as I could come up with & like you I have never heard of it before.

I see now, I didn't relise you were pasting values into the cells.