Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parent child relation between two rows in an excel sheet
Hi,
I want to know if there is any way in which we can determine the parent/child relation (i.e. one row is dependent on another row) using .NET. My requirement is that when I have this kind of relation I should allow the deletion of parent row. Please let me know if anyone has any idea about this. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parent child relation between two rows in an excel sheet
or maybe that you mean "merger range"
if A1:A3 are a merger range SecondRow = Range("A1").Item(2).Row the SecondRow's return value will be 2 -- isabelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
parent/child relationship between rows? | Excel Worksheet Functions | |||
Creating child worksheet from parent | Excel Worksheet Functions | |||
Pivot Table - Parent to Child Data | Excel Discussion (Misc queries) | |||
Finding loops in parent/child relationships | Excel Discussion (Misc queries) | |||
Sorting Parent Child | Excel Worksheet Functions |