Parent child relation between two rows in an excel sheet
there isn't no parent/child relation, but you can use "offset" to determine the line before or thereafter
Sub test()
With ActiveCell
MsgBox .Row
MsgBox .Offset(-1, 0).Row
MsgBox .Offset(1, 0).Row
End With
End Sub
--
isabelle
|