DirectDependents of a Workbook DefinedName

DirectDependents of a Workbook DefinedName

Posted by: niels on 12 November 2023, 3:12 am EST

• 

  niels

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 November 2023, 3:12 am EST - Updated 12 November 2023, 3:23 am EST

  How to get DirectDependents of a Workbook DefinedName (IName) ?
  
  The DefinedName contains a value (not a range reference)
  
  16.2.20231.0

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 12 November 2023, 11:14 pm EST

  Hi Niels,

  As per our understanding, you have defined names for some cells having values and you want to find the DirectDependents of these cells using these names.

  In case this is the requirement, we would like to inform you that there does not exist a way to find the dependents of defined names. Dependents and Precedents indicates cells / cell ranges only. When the defined name is used, it’s evaluated and the cell will depends on cells / cell ranges which are defined inside the defined name.

  However, you can find the direct dependents of a cell from its predefined tag as shown in the following line of code:

  fpSpread1.AsWorkbook().ActiveSheet.Cells["B2"].DirectDependents.Address();

  Kindly refer to the attached sample for full implementation. See DefinedNameDependent.zip.

  Please let us know if your requirement differs from our understanding.

  Thanks & Regards,
  
  Aastha