Use code like the following in your Worksheet_Change event handler to refer
to the cell above the Target cell:

Dim rngCellAbove as Range

Set rngCellAbove = Target.Offset(-1,0)

.... then do whatever you want with rngCellAbove.

In similar fashion, the cell below would be Target.Offset(1,0).

--
Regards,
Bill Renaud