navigating Cells in VBA without losing target for my offset

[wobbles]

Can anyone please tell me how i can change the content of one cell in a fixed location without losing reference to the cell that triggered the worksheet_change (target) because once i change it i want to act with the cell that triggered or nearby with .offset

when i try it my cell references go so wrong

 

[mikerickson]

Something like

With Target
    Application.EnableEvents = False
    .Offset(3, 14).Value = "distant cell"
    Application.EnableEvents = True
End With

The Application.EnableEvents is in there so that changing the .Offset cell doesn't trigger another Worksheet_Change event.

 

[njimack]

You don't need to select cells to perform actions on them, and even if you did, the Target cell wouldn't change.

Please explain what you're trying to do and post your existing code.