Returns the cell text unit item to process during consolidation, calculation, or translation. This function can be used in these types of rules:
Calculation
Translation
Consolidation
HS.OpenCellTextUnit("", "[Default]", "Entity", "Ascending")
The entry for the specified item.
Set MyCellTextUnit = HS.OpenCellTextUnit("", "[Default]", "Entity", "Ascending") NumItems= MyCellTextUnit.GetNumItems For i = 0 to NumItems - 1 Scenario = MyCellTextUnit.Item(i).Scenario Year = MyCellTextUnit.Item(i).Year Period = MyCellTextUnit.Item(i).Period Entity = MyCellTextUnit.Item(i).Entity Value = MyCellTextUnit.Item(i).Value Account = MyCellTextUnit.Item(i).Account ICP = MyCellTextUnit.Item(i).ICP Flow = MyCellTextUnit.Item(i)Custom("Flows") Nature = MyCellTextUnit.Item(i).Custom("Nature") ... ... ... CellText = MyCellTextUnit.Item(i).CellText POV = MyCellTextUnit.Item(i).POV Next