I need to do data manipulation based on a particular cell being changed, I can try to work it on sheet change , but cell change would be a lot easier, if it is possible , please advise correct syntax also best location to put the code
On the sheet you want to do this action, Right click it's Tab - View code.
Paste the following there.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MyRange As Range, c As Range
Set MyRange = Intersect(Target, Range("C10:C16"))
If MyRange Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each c In MyRange
c.Offset(0, 1).Value = "Cell " & c.Address & " was just changed"
Application.EnableEvents = True