DefinedName.LocalSheetIndex Property

Gets or sets the local sheet index of the defined name. If the local sheet index is -1, defined name is global.

public int LocalSheetIndex {get; set;}