View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default 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