property Item.CellParent ([ColIndex as Variant]) as Variant
Retrieves the parent of an inner cell.

TypeDescription
ColIndex as Variant A Long expression that specifies the index of the column, or A String expression that specifies the name of the column to query for cell's parent.
Variant A Long expression that indicates the handle of the cell's parent, or zero if no parent
Use the CellParent property to get the parent of the inner cell. The SplitCell method splits a cell in two cells ( the newly created cell is called inner cell ). Use the InnerCell property to get the inner cell. The CellParent property gets 0 if the cell is not an inner cell. The parent cell is always displayed to the left side of the cell. The inner cell ( InnerCell ) is displayed to the right side of the cell. Use the CellWidth property to specify the width of the inner cell. The UnsplitCell method unsplits the cell. The Parent property indicates the item's parent.