Free Support Forum - aspose.com

Retrieving the reference formula of a range

Hi,

My excel file contains many named cells (Insert->New->Define).

Is it possible to retrieve the formula (Excel "reference" field) in order to check the consistency of the formula.

My objective is to check if a named range is still valid (as the referenced cells may have been deleted in the meantime).

Thanks,

Omid.

Hi Omid,

You can try to use Excel.Worksheets.Names collection to get those defined names.

Excellent, it works pretty well.

Thanks,

Omid.